公开(公告)号：US12242506B2

公开(公告)日：2025-03-04

申请号：US18498657

申请日：2023-10-31

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Khondokar Sami Iqram ,  Subramanian Muralidhar ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/00 ,  G06F16/27 ,  H04L9/40

Abstract: A database system can configure network devices, such as a primary database in a multi-tenant deployment and a secondary database in a private deployment, to send and receive sequence messages, such as input data indicative of a selection of a link. The database system can create a secure share area in the private deployment in response to receiving the input data indicative of the selection of the link. The database system can replicate the data from the multi-tenant deployment to the secure share area in the private deployment and share the replicated data from the secure share area to the secondary database hosted in the private deployment.

公开(公告)号：US12135734B2

公开(公告)日：2024-11-05

申请号：US18324787

申请日：2023-05-26

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/30 ,  G06F16/21 ,  G06F16/25 ,  G06F16/27

Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.

公开(公告)号：US12130835B2

公开(公告)日：2024-10-29

申请号：US18447897

申请日：2023-08-10

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F16/27 ,  G06Q30/0201 ,  G06Q30/0601

CPC classification number: G06F16/27 ,  G06Q30/0206 ,  G06Q30/0601

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. The data listing distribution component distributes the data dictionaries to various remote deployments in a data exchange by using a global messaging framework and replication method. For example, the data listing distribution component replicates a data dictionary generated for the listing and its shared data from a source deployment to one or more destination deployments associated with various geographic regions. The data listing distribution component distributes the listing to the various remote deployments to allow for the listing, including its shared data and data dictionary, to be accessed by users within the geographic region associated with the remote deployment.

公开(公告)号：US12032595B2

公开(公告)日：2024-07-09

申请号：US18128130

申请日：2023-03-29

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

IPC: G06F16/00 ,  G06F16/182 ,  G06F16/245 ,  G06F16/27

CPC classification number: G06F16/273 ,  G06F16/1844 ,  G06F16/245

Abstract: Techniques for database replication for a remote deployment include a method performed by a data platform executing instructions on at least one hardware processor. The method includes detecting receipt of a database replication request associated with a data consumer. The database replication request is requesting availability of an instance of a primary deployment database at a remote deployment of a data platform. In response to detecting the receipt of the database replication request, an account of a data provider at the remote deployment of the data platform is provisioned with a set of replication-preparation objects associated with the primary deployment database. A database refresh operation is invoked, causing database data be pushed from the primary deployment database to a database shell in the account of the data provider at the remote deployment, to create the instance of the primary deployment database.

公开(公告)号：US20240176711A1

公开(公告)日：2024-05-30

申请号：US18329348

申请日：2023-06-05

Applicant: Snowflake Inc.

Inventor： Loc Duc Bui ,  Hitesh Madan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini ,  Di Wu

IPC: G06F11/20 ,  G06F16/25 ,  G06F16/27

CPC classification number: G06F11/203 ,  G06F16/256 ,  G06F16/27

Abstract: The subject technology determines a set of share objects in a replication group. The subject technology, for each object from the set of share objects, determines a set of permissions for a set of objects of databases that has been granted to each share object from the replication group. The subject technology, for each permission from the set of permissions, determines a set of dependencies, the set of dependencies comprising a second set of objects. The subject technology generates a graph structure based at least in part on the set of share objects, the set of permissions, and the set of dependencies. The subject technology traverses at least a portion of the graph structure to determine a final set of dependencies for replication. The subject technology performs a replication process based at least in part on the final set of dependencies.

公开(公告)号：US11929986B1

公开(公告)日：2024-03-12

申请号：US18325388

申请日：2023-05-30

Applicant: Snowflake Inc.

Inventor： Khondokar Sami Igram ,  Laxman Mamidi ,  Sanjay Srivastava ,  Chieh-Sheng Wang ,  Di Wu

IPC: H04L9/40 ,  G06F21/62

CPC classification number: H04L63/0263 ,  G06F21/6218 ,  H04L63/0272 ,  H04L63/083

Abstract: Methods, systems, and computer programs are presented for enabling automated secure data sharing from a private cloud region to a public cloud region and vice versa. A cloud data platform confirms a relationship establishment procedure between a provider and a consumer is recorded with a cloud data platform, the provider being associated with a private cloud deployment and the consumer being associated with a public cloud deployment in a public region. The cloud data platform enables disabling of a firewall policy that is preventing data traffic between the private cloud deployment and the public cloud deployment and enables data sharing between the private cloud deployment and the public cloud deployment. The cloud data platform enables data sharing in a database of the cloud data platform.

公开(公告)号：US20230297591A1

公开(公告)日：2023-09-21

申请号：US18324787

申请日：2023-05-26

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/27 ,  G06F16/21 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F16/213 ,  G06F16/256

Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.

公开(公告)号：US11163797B1

公开(公告)日：2021-11-02

申请号：US17302396

申请日：2021-04-30

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

IPC: G06F16/27

Abstract: Disclosed herein are systems and methods for database replication to a remote deployment with automated fulfillment. In an embodiment, a data platform provisions a remote-deployment account of a data provider at a remote deployment of the data platform with a set of one or more replication-preparation objects associated with a primary-deployment database that is resident in a primary-deployment account of the data provider at a primary deployment of the data platform. After the provisioning, the data platform detects receipt of a database-replication request associated with a data consumer, requesting availability of a local instance of the primary-deployment database in the remote-deployment account of the data provider. The data platform responsively performs one or more remote-deployment-activation operations, which makes available to the data consumer a local instance of the primary-deployment database in the remote-deployment account of the data provider at the remote deployment of the data platform.

公开(公告)号：US20250088486A1

公开(公告)日：2025-03-13

申请号：US18958641

申请日：2024-11-25

Applicant: Snowflake Inc.

Inventor： Khondokar Sami Iqram ,  Laxman Mamidi ,  Sanjay Srivastava ,  Chieh-Sheng Wang ,  Di Wu

IPC: H04L9/40 ,  G06F21/62

Abstract: A method for data sharing between cloud deployments is disclosed. A provider in a virtual private cloud (VPC) deployment generates a listing of data for sharing with a consumer in a public multi-tenant deployment. After creating a public account and transmitting a link associated with the listing to the consumer, the method responds to the consumer's selection of the link by automatically creating a secure shared area in the VPC deployment. The method includes replicating both a database and share object associated with the listing into the secure shared area as respective replicas. The replicated objects are then shared with the consumer account as data share objects, enabling the consumer to launch them in a consumer mounted database. The method concludes by enabling the consumer to perform database operations on the provider's data within the VPC deployment, ensuring secure and efficient data sharing between the cloud environments.

公开(公告)号：US20240289351A1

公开(公告)日：2024-08-29

申请号：US18637833

申请日：2024-04-17

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

IPC: G06F16/27 ,  G06F16/182 ,  G06F16/245

CPC classification number: G06F16/273 ,  G06F16/1844 ,  G06F16/245

Abstract: Techniques for remote deployment replication using data objects preparation objects include detecting at an account of a data provider at the remote deployment, a replication request for availability of an instance of a primary deployment database to account of a data consumer at the remote deployment. Responsive to the replication request, the account of the data provider at the remote deployment is provisioned with a plurality of data objects associated with the primary deployment database. A refresh operation is invoked using at least one data object of the plurality of data objects at the remote deployment, to generate the instance of the primary deployment database in the account of the data consumer.