Share-based replication
    31.
    发明授权

    公开(公告)号:US12222828B2

    公开(公告)日:2025-02-11

    申请号:US18329348

    申请日:2023-06-05

    Applicant: Snowflake Inc.

    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.

    Bi-directional data sharing between private and public clouds

    公开(公告)号:US12184610B2

    公开(公告)日:2024-12-31

    申请号:US18429215

    申请日:2024-01-31

    Applicant: Snowflake Inc.

    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.

    COMPATIBILITY CHECKER FOR LISTING AUTO FULFILLMENT

    公开(公告)号:US20240346038A1

    公开(公告)日:2024-10-17

    申请号:US18301490

    申请日:2023-04-17

    Applicant: Snowflake Inc.

    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.

    DATA DICTIONARY METADATA FOR MARKETPLACE LISTINGS

    公开(公告)号:US20240256501A1

    公开(公告)日:2024-08-01

    申请号:US18635637

    申请日:2024-04-15

    Applicant: Snowflake Inc.

    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.

    Generating data dictionary metadata

    公开(公告)号:US12050710B2

    公开(公告)日:2024-07-30

    申请号:US18306704

    申请日:2023-04-25

    Applicant: Snowflake Inc.

    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.

    BI-DIRECTIONAL DATA SHARING BETWEEN PRIVATE AND PUBLIC CLOUDS

    公开(公告)号:US20240171544A1

    公开(公告)日:2024-05-23

    申请号:US18429215

    申请日:2024-01-31

    Applicant: Snowflake Inc.

    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.

    DATA DICTIONARY METADATA FOR MARKETPLACE LISTINGS

    公开(公告)号:US20240111735A1

    公开(公告)日:2024-04-04

    申请号:US18051447

    申请日:2022-10-31

    Applicant: Snowflake Inc.

    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.

    BACKGROUND JOB BASED REFRESH FULFILLMENT
    38.
    发明公开

    公开(公告)号:US20240095232A1

    公开(公告)日:2024-03-21

    申请号:US18521790

    申请日:2023-11-28

    Applicant: Snowflake Inc.

    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.

    Database configurations for remote deployments

    公开(公告)号:US11645306B2

    公开(公告)日:2023-05-09

    申请号:US17662963

    申请日:2022-05-11

    Applicant: Snowflake Inc.

    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.

    AUTOMATED DATABASE REPLICATION AT A REMOTE DEPLOYMENT

    公开(公告)号:US20220300532A1

    公开(公告)日:2022-09-22

    申请号:US17490543

    申请日:2021-09-30

    Applicant: Snowflake Inc.

    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.

Patent Agency Ranking