-
公开(公告)号:US12222828B2
公开(公告)日:2025-02-11
申请号:US18329348
申请日:2023-06-05
Applicant: Snowflake Inc.
Inventor: Loc Duc Bui , Hitesh Madan , Nithin Mahesh , Subramanian Muralidhar , Sahaj Saini , Di Wu
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.
-
公开(公告)号:US12184610B2
公开(公告)日:2024-12-31
申请号:US18429215
申请日:2024-01-31
Applicant: Snowflake Inc.
Inventor: Khondokar Sami Iqram , Laxman Mamidi , Sanjay Srivastava , Chieh-Sheng Wang , Di Wu
Abstract: A method for secure data synchronization and sharing between distinct cloud environments is disclosed. The method involves establishing a trust relationship between a data provider's private cloud deployment and a data consumer's public cloud deployment. Utilizing hardware processors, a cross-region group sharing token is generated and validated to facilitate secure communication and data traffic between the two cloud deployments. Upon validation, a firewall policy that previously restricted data exchange is disabled, allowing for the replication of a target database from the private cloud to a secure share area accessible by the public cloud deployment. The data consumer is then enabled to access and utilize the replicated database within this secure area. The method ensures consistent data management across both deployments by managing the synchronization of the replicated database with the data provider's original database, thereby maintaining data consistency and integrity.
-
公开(公告)号:US20240346038A1
公开(公告)日:2024-10-17
申请号:US18301490
申请日:2023-04-17
Applicant: Snowflake Inc.
Inventor: Hitesh Madan , Chieh-Sheng Wang , Di Wu
CPC classification number: G06F16/27 , G06F16/2365
Abstract: Provided herein are systems and methods for compatibility verification for listing auto-fulfillment. A system includes at least one hardware processor coupled to a memory and configured to decode a request for replication of data from a primary deployment account of a data provider to an account of a data consumer. A share object is retrieved in response to the request. The share object specifies a first plurality of data objects associated with the data. A determination is performed of the compatibility of each data object of the first plurality of data objects with the replication. A notification of the compatibility of each data object of the first plurality of data objects is output to the primary deployment account of the data provider.
-
公开(公告)号:US20240256501A1
公开(公告)日:2024-08-01
申请号:US18635637
申请日:2024-04-15
Applicant: Snowflake Inc.
Inventor: Durga Mahesh Arikatla , Robert K. Chao , Li He , Joyce Lam , Xinyue Liu , Subramanian Muralidhar , Vishnu Dutt Paladugu , Shakhina Pulatova , Stephanie Stillman , Xin Wen , Di Wu , Ziqi Xu
IPC: G06F16/21
CPC classification number: G06F16/213
Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data, including the individual objects, such as the individual tables, schemas, views, and functions. The shared data and each individual data object may be described in the data dictionary by a set of data fields that corresponds to the shared dataset or the object type of the individual object. The data dictionary can be presented to data consumers along with the description of the listing to provide data consumers with a comprehensive description of the shared data provided by a listing, including a high-level summary of the shared data and description of each individual object included in the shared data. The data dictionary allows data consumers to understand the contents of the shared data and how to use the shared data.
-
公开(公告)号:US12050710B2
公开(公告)日:2024-07-30
申请号:US18306704
申请日:2023-04-25
Applicant: Snowflake Inc.
Inventor: Durga Mahesh Arikatla , Subramanian Muralidhar , Vishnu Dutt Paladugu , Shakhina Pulatova , Di Wu , Ziqi Xu
CPC classification number: G06F21/6218 , G06F21/604 , G06F2221/2141
Abstract: A data dictionary generation system utilizes a background service that is programmed to automatically populate and update a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data overall as well as the individual objects included in the listing, such as the individual tables, schemas, views, and functions. To generate the data dictionary, the data dictionary generation system analyzes the shared data to identify objects, identifies a set of data fields associated with each identified object and populates the set of data fields associated with each identified object based on the shared data offered by the listing. To ensure that a data dictionary for each listing remains up to date, the data dictionary generation system periodically scans the listings to identify any changes to share access granted to the listings.
-
公开(公告)号:US20240171544A1
公开(公告)日:2024-05-23
申请号:US18429215
申请日:2024-01-31
Applicant: Snowflake Inc.
Inventor: Khondokar Sami Iqram , Laxman Mamidi , Sanjay Srivastava , Chieh-Sheng Wang , Di Wu
CPC classification number: H04L63/0263 , G06F21/6218 , H04L63/0272 , H04L63/083
Abstract: A method for secure data synchronization and sharing between distinct cloud environments is disclosed. The method involves establishing a trust relationship between a data provider's private cloud deployment and a data consumer's public cloud deployment. Utilizing hardware processors, a cross-region group sharing token is generated and validated to facilitate secure communication and data traffic between the two cloud deployments. Upon validation, a firewall policy that previously restricted data exchange is disabled, allowing for the replication of a target database from the private cloud to a secure share area accessible by the public cloud deployment. The data consumer is then enabled to access and utilize the replicated database within this secure area. The method ensures consistent data management across both deployments by managing the synchronization of the replicated database with the data provider's original database, thereby maintaining data consistency and integrity.
-
公开(公告)号:US20240111735A1
公开(公告)日:2024-04-04
申请号:US18051447
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Durga Mahesh Arikatla , Robert K. Chao , Li He , Joyce Lam , Xinyue Liu , Subramanian Muralidhar , Vishnu Dutt Paladugu , Shakhina Pulatova , Stephanie Stillman , Xin Wen , Di Wu , Ziqi Xu
IPC: G06F16/21
CPC classification number: G06F16/213
Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data, including the individual objects, such as the individual tables, schemas, views, and functions. The shared data and each individual data object may be described in the data dictionary by a set of data fields that corresponds to the shared dataset or the object type of the individual object. The data dictionary can be presented to data consumers along with the description of the listing to provide data consumers with a comprehensive description of the shared data provided by a listing, including a high-level summary of the shared data and description of each individual object included in the shared data. The data dictionary allows data consumers to understand the contents of the shared data and how to use the shared data.
-
公开(公告)号:US20240095232A1
公开(公告)日:2024-03-21
申请号:US18521790
申请日:2023-11-28
Applicant: Snowflake Inc.
Inventor: Durga Mahesh Arikatla , Laxman Mamidi , Subramanian Muralidhar , Chieh-Sheng Wang , Di Wu
CPC classification number: G06F16/2365 , G06F16/27
Abstract: A process of fulfilling a database deployment request for a data platform. A compute service manager of the data platform scans one or more accounts of a consumer region of the data platform for a pending listing fulfillment request, where the pending listing request includes a request for deployment of a consumer database and an associated share of grant metadata of the consumer database within the consumer region. When the compute service manager determines that an account of the one or more accounts has a pending listing fulfillment request, the compute service manager determines a listing for the pending listing fulfillment request based on listing data of the account. The compute service manager determines that no other fulfillment task is scheduled for the pending listing fulfillment request and schedules a background fulfillment task to perform the fulfillment process for the pending listing fulfillment request.
-
公开(公告)号:US11645306B2
公开(公告)日:2023-05-09
申请号:US17662963
申请日:2022-05-11
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC: G06F16/00 , G06F16/27 , G06F16/182 , G06F16/245
CPC classification number: G06F16/273 , G06F16/1844 , G06F16/245
Abstract: Techniques for database configurations for remote deployments include a method performed by a data platform executing instructions on at least one processor. The method includes provisioning by at least one hardware processor, a remote deployment of a data platform with a plurality of objects. The plurality of objects includes at least one task object associated with a primary deployment of the data platform. The method further includes detecting using the at least one task object of the plurality of objects, a request to replicate a database stored at the primary deployment of the data platform at the remote deployment. Responsive to the request, database data is pushed from the database stored at the primary deployment to at least a second object of the plurality of objects provisioned at the remote deployment.
-
公开(公告)号:US20220300532A1
公开(公告)日:2022-09-22
申请号:US17490543
申请日:2021-09-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.
-
-
-
-
-
-
-
-
-