-
公开(公告)号：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
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.
-
公开(公告)号：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.
-
公开(公告)号：US20240037263A1
公开(公告)日：2024-02-01
申请号：US18378575
申请日：2023-10-10
Applicant: Snowflake Inc.
Inventor： Damien Carru , Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Subramanian Muralidhar , Bowen Zhang
CPC classification number: G06F21/6218 , G06F16/256 , G06F16/21 , G06F2221/2141
Abstract: Embodiments of the present disclosure relate to sharing data using database roles. Database roles are generated within a database container of a provider account. Grants to a particular subset of the plurality of data objects of the database container may be assigned to each of the database roles, and each of the database roles are granted to a share object. The share object is mounted within a consumer account to generate an imported copy of each of the database roles. The imported copy of one or more of the database roles is granted to each of one or more account level roles of the consumer account. When a new object is added to a particular database role, it is immediately available for consumption by any account level roles to which the imported copy of the particular database role has been granted.
-
公开(公告)号：US11822689B2
公开(公告)日：2023-11-21
申请号：US18109191
申请日：2023-02-13
Applicant: Snowflake Inc.
Inventor： Damien Carru , Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Subramanian Muralidhar , Bowen Zhang
CPC classification number: G06F21/6218 , G06F16/21 , G06F16/256 , G06F2221/2141
Abstract: Embodiments of the present disclosure relate to sharing database roles using hidden roles. A database role may be generated within a database container having a plurality of data objects, wherein the database role exists exclusively within the database container. A set of grants to a particular subset of the plurality of data objects of the database container may be assigned to the database role and the database role may be granted to the share object. The share object is mounted within a consumer account to generate an imported database container within the consumer account, the imported database container including an imported copy of the database role. The imported copy of the database role may be granted to each of one or more account level roles of the consumer account to share the particular subset of the plurality of data objects without creating proxy objects in the consumer account that represent the particular subset of the plurality of data objects.
-
公开(公告)号：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
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.
-
Patent Agency Ranking
公开(公告)号：US20230244642A1
公开(公告)日：2023-08-03
申请号：US18134186
申请日：2023-04-13
Applicant: SNOWFLAKE INC.
Inventor： Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Vishnu Dutt Paladugu , Bowen Zhang
IPC: G06F16/182 , G06F16/11 , G06F9/54 , G06F16/17
CPC classification number: G06F16/1844 , G06F16/128 , G06F9/546 , G06F16/1827 , G06F16/1734
Abstract: Provided herein are systems and methods for replicating share objects to remote deployments. An example method includes generating, at a second deployment in a data exchange, a replica of a share object included in a first deployment of the data exchange. The share object grants privileges to a first account to access a first database of the first deployment, wherein the first database comprises a database object. The method also includes retrieving, at the first deployment, share grant metadata from the share object of the first deployment, wherein the share grant metadata includes a reference to the database object and allows the first account to use the database object. The method also includes transmitting a message comprising the share grant metadata to the replica in the second deployment. The share grant metadata in the replica allows a second account to use the database object replicated in the second deployment.
-
公开(公告)号：US11372891B2
公开(公告)日：2022-06-28
申请号：US17226141
申请日：2021-04-09
Applicant: Snowflake Inc.
Inventor： Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
Abstract: A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor then performs incremental replication of the data table by causing a full inventory replication at a next refresh to be executed for provider accounts associated with the provider account identifiers in the entitlements table. Other embodiments are also described herein.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：US20240061860A1
公开(公告)日：2024-02-22
申请号：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
CPC classification number: G06F16/27 , H04L63/0272
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.
-
-
-
-
-
-
-
-
-
Search Results
53
records
(took 0.024 seconds)
