Private data exchange metrics sharing

    公开(公告)号:US11470089B2

    公开(公告)日:2022-10-11

    申请号:US17666473

    申请日:2022-02-07

    Applicant: Snowflake Inc.

    Abstract: Providing access to metrics on a private data exchange is described. An example computer-implemented method can include executing one or more queries against data referenced by a data listing of a data exchange, the data exchange comprising a plurality of data listings provided by one or more data providers, gathering consumer information based on the one or more queries, assigning privileges that grant access to the consumer information to a share object, in response to the share object being added to a list of consumed share objects of a data provider that provided the data listing, generating a database that references the consumer information based on the share object, and granting access to the database to the data provider that provided the data listing.

    Share replication between remote deployments

    公开(公告)号:US11461285B2

    公开(公告)日:2022-10-04

    申请号:US17694335

    申请日:2022-03-14

    Applicant: SNOWFLAKE INC.

    Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may include generating a global representation of a share object of a first database account located in a first region. The share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account. The method may further include, in response to a database refresh command received from a second database account associated with a database replica located in a second region, replicating the set of objects of the database to the database replica. The method may further include, in response to a share refresh command received from the second database account, replicating the grant metadata to a share object replica located in the second region.

    AUTOMATED QUERY RETRY IN A DATABASE SYSTEM

    公开(公告)号:US20220269573A1

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

    申请号:US17663253

    申请日:2022-05-13

    Applicant: Snowflake Inc.

    Abstract: Techniques for automated query retry in a database platform include assigning by at least one hardware processor a first execution of a query directed to database data to a first execution node of a plurality of execution nodes of an execution platform. The first execution node uses a first set of configurations during the first execution. The techniques further include determining that the first execution of the query by the first execution node results in a failed execution. The query is transferred to a second execution node of the plurality of execution nodes. A second execution of the query at the second execution node is caused. The second execution node uses a second set of configurations during the second execution. A cause of the failed execution at the first execution node is determined based on a result of the second execution of the query at the second execution node.

    System and method for global data sharing

    公开(公告)号:US11418577B1

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

    申请号:US17709689

    申请日:2022-03-31

    Applicant: SNOWFLAKE INC.

    Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include receiving data sharing information from a data provider for sharing a data set in a data exchange from a first cloud computing entity to a set of second cloud computing entities. In response to receiving the data sharing information, the method may also include creating an account with each of the set of second cloud computing entities. The method may also further include sharing the data set from the first cloud computing entity with the set of second cloud computing entities using at least the corresponding account of that second cloud computing entity.

    Decoupling internal and external tasks in a database environment

    公开(公告)号:US11372740B2

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

    申请号:US17007589

    申请日:2020-08-31

    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.

    SHARE REPLICATION BETWEEN REMOTE DEPLOYMENTS

    公开(公告)号:US20220197872A1

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

    申请号:US17694335

    申请日:2022-03-14

    Applicant: SNOWFLAKE INC.

    Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may include generating a global representation of a share object of a first database account located in a first region. The share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account. The method may further include, in response to a database refresh command received from a second database account associated with a database replica located in a second region, replicating the set of objects of the database to the database replica. The method may further include, in response to a share refresh command received from the second database account, replicating the grant metadata to a share object replica located in the second region.

Patent Agency Ranking