ACCESSING LISTINGS IN A DATA EXCHANGE

    公开(公告)号:US20220309071A1

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

    申请号:US17839248

    申请日:2022-06-13

    Applicant: SNOWFLAKE INC.

    Abstract: A method of operating a data exchange includes creating a first listing referencing data of a first database of a plurality of databases, wherein the first listing comprises access controls and a data share associated with a first user, the access controls defining portions of the first database that are accessible by a second user, receiving a request from the second user for a bidirectional share between the portions of the first database that are accessible by the second user and portions of a second database controlled by the second user, and receiving an instruction from the first user to perform a database operation referencing data of the bidirectional share between the portions of the first database that are accessible by the second user and the portions of the second database controlled by the second user.

    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.

    Native applications using database roles

    公开(公告)号:US11436362B1

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

    申请号:US17535529

    申请日:2021-11-24

    Applicant: Snowflake Inc.

    Abstract: Embodiments of the present disclosure enable users of a data sharing system to build native applications that can be shared with other users of the data sharing system. The native applications can be published and discovered in the data sharing system like any other data listing, and consumers can install them in their local data sharing system account to serve their data processing needs. A provider may define an installation script for installing an application and create a share object to which the installation script may be attached. In response to an imported database being created in a consumer account based on the share object, a native application framework may automatically execute the installation script in the consumer account and may create a set of database roles to manage execution of the application in the consumer account.

    Automated database replication at a remote deployment

    公开(公告)号:US11436255B1

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

    申请号: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.

    Decoupling internal and external tasks in a database environment

    公开(公告)号:US11409626B2

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

    申请号:US16555996

    申请日:2019-08-29

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

    DATA SHARING USING ALIAS OBJECTS
    276.
    发明申请

    公开(公告)号:US20220222365A1

    公开(公告)日:2022-07-14

    申请号:US17710056

    申请日:2022-03-31

    Applicant: SNOWFLAKE INC.

    Abstract: A method for sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.

    Data sharing in a multi-tenant database system

    公开(公告)号:US11386220B2

    公开(公告)日:2022-07-12

    申请号:US17539145

    申请日:2021-11-30

    Applicant: SNOWFLAKE INC.

    Abstract: A method for sharing data in a multi-tenant database includes receiving, by a target account of a multiple tenant database, access rights of a share object in a first account of the multiple tenant database, wherein the share object having access rights to a database object of the first account and wherein access to the database object of the first account by the target account is based on the access rights of the share object. The method also includes receiving, by one or more processors of the target account, access rights to an alias object, wherein the alias object references the database object of the first account.

    ACCESSING LISTINGS IN A DATA EXCHANGE

    公开(公告)号:US20220215033A1

    公开(公告)日:2022-07-07

    申请号:US17704783

    申请日:2022-03-25

    Applicant: SNOWFLAKE INC.

    Abstract: A method for accessing listings in a data exchange includes creating a first listing in a data exchange, the first listing referencing a first database of a plurality of databases and specifying identity-based sharing of the first database, creating a second listing in the data exchange, the second listing referencing a second database of the plurality of databases and data of the first database shared according to the identity-based sharing of the first database, and receiving an instruction from a user of the data exchange, the instruction referencing the second listing and instructing the addition of the second listing to a set of consumed data shares accessible by the user.

    TABLE DATA PROCESSING USING A CHANGE TRACKING STREAM

    公开(公告)号:US20220188287A1

    公开(公告)日:2022-06-16

    申请号:US17653527

    申请日:2022-03-04

    Applicant: Snowflake Inc.

    Abstract: A system includes one or more processors and data storage containing instructions executable by the one or more processors to perform operations. The operations include storing table data in a plurality of partitions of a storage device. Metadata is retrieved from a first partition of the plurality of partitions. The metadata includes a plurality of change tracking entries stored as a change tracking stream. A lineage of modifications made to the table data is determined using the plurality of change tracking entries. A report of one or more transactions performed on the table data is generated. The one or more transactions are included in the lineage of modifications.

Patent Agency Ranking