DIRECTING REQUESTS TO DATABASES BASED ON CLIENT ACCOUNT ASSOCIATION

    公开(公告)号:US20250053576A1

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

    申请号:US18931781

    申请日:2024-10-30

    Applicant: Snowflake Inc.

    Abstract: Systems of methods of directing requests to databases based on client account association is disclosed. A method includes determining a first client account associated with a first request to perform a first transaction. The method includes determining a second client account associated with a second request to perform a second transaction. The method includes selecting, for the first request, a primary deployment that stores a first dataset responsive to determining the first client account associated with the first request. The method includes selecting, for the second request, a secondary deployment that stores a second dataset that includes the first dataset responsive to determining the second client account associated with the second request. The method includes executing, while the primary deployment and the secondary deployment are both available, the first transaction on the first dataset at the primary deployment and the second transaction on the second dataset at the secondary deployment.

    DIRECTING QUERIES TO ENCRYPTED DATABASE FILES

    公开(公告)号:US20230205912A1

    公开(公告)日:2023-06-29

    申请号:US18111821

    申请日:2023-02-20

    Applicant: Snowflake Inc.

    CPC classification number: G06F21/6227 G06F21/602 G06F2221/2107

    Abstract: A method for directing queries to encrypted database files includes acquiring a mapping that links a first encrypted file with a different encrypted file. The first encrypted file is generated based on a first encryption key. The method includes generating, by one or more processors based on the mapping, an updated mapping to link a second encrypted file with the different encrypted file. The second encrypted file is generated based on a second encryption key. The method includes determining an arrival time of a query. The method includes directing, based on the arrival time, the query to the first encrypted file or the second encrypted file.

    SECURE DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM

    公开(公告)号:US20220114277A1

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

    申请号:US17559226

    申请日:2021-12-22

    Applicant: SNOWFLAKE INC.

    Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes receiving, by a cross-account, a grant to access a share object comprising a secure view and usage functionality associated with a secure user-defined function (UDF) to underlying data. The method includes accessing, by the cross-account, the share object using the grant. The method includes sending a request to a share component to cause the share component to implement the secure view and the usage functionality associated with the secure UDF. The method includes sending a query to the share component to cause the share component to implement the secure UDF.

    MESSAGE-BASED DATABASE REPLICATION

    公开(公告)号:US20210344655A1

    公开(公告)日:2021-11-04

    申请号:US17219700

    申请日:2021-03-31

    Applicant: Snowflake Inc.

    Abstract: A networked device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences of messages, such as replicated data, using one or more keypairs and wrapping keys. The sequences of messages can include an initial set of messages that are encrypted by a wrapping key, and further include another set of messages that are encrypted by a replaced staggered key. The sequence of messages can be configured to be decrypted without exporting keys of hardware security modules.

    DATA SHARING USING ALIAS OBJECTS
    7.
    发明申请

    公开(公告)号:US20210312070A1

    公开(公告)日:2021-10-07

    申请号:US17354972

    申请日:2021-06-22

    Applicant: SNOWFLAKE INC.

    Abstract: A method of 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.

    STORING METADATA USING DATA STRUCTURES IN DATABASE SYSTEMS

    公开(公告)号:US20210049179A1

    公开(公告)日:2021-02-18

    申请号:US17086279

    申请日:2020-10-30

    Applicant: Snowflake Inc.

    Abstract: The subject technology receives first metadata corresponding to a set of micro-partitions. The subject technology stores a first data structure and a second data structure in storage as a first file and a second file, first data structure including the first metadata and a second data structure including second metadata, the first metadata corresponding to a set of micro-partitions, the second metadata for a grouping of the first metadata, the second data structure including information associating the second metadata to the first metadata. The subject technology stores third metadata for a table, the third metadata comprising: cumulative table metadata comprising global information about a plurality of micro-partitions of the table, the cumulative table metadata being stored in a metadata micro-partition associated with the table.

    DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM

    公开(公告)号:US20200257817A1

    公开(公告)日:2020-08-13

    申请号:US16833482

    申请日:2020-03-27

    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.

Patent Agency Ranking