公开(公告)号：US20220239728A1

公开(公告)日：2022-07-28

申请号：US17709689

申请日：2022-03-31

Applicant: SNOWFLAKE INC.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Matthew Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

IPC: H04L67/10 ,  H04L9/40 ,  H04L41/50 ,  H04L67/51 ,  G06F16/23 ,  G06F21/62 ,  H04L67/1097 ,  H04L67/53

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.

公开(公告)号：US20220237161A1

公开(公告)日：2022-07-28

申请号：US17721938

申请日：2022-04-15

Applicant: Snowflake Inc.

Inventor： Jiaqi Yan ,  Qiuye Jin ,  Shrainik Jain ,  Stratis Viglas ,  Allison Lee

IPC: G06F16/21 ,  G06F11/34 ,  G06F11/07 ,  G06F16/215 ,  G06F11/30 ,  G06F16/2453

Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. The method includes determining a workload based on one or more client queries to be rerun for testing the feature release. The method further includes repeatedly executing a test run of the workload to identify whether there is a performance difference in the test run. The method further includes re-execute, in response to identifying the performance difference, the test run using resources with a different concurrency to identify whether the performance difference still exists. The method further includes flagging the performance difference as a false positive in response to identifying that the performance difference no longer exists when the test run is re-executed using the resources with different concurrency.

公开(公告)号：US20220222247A1

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

申请号：US17656960

申请日：2022-03-29

Applicant: Snowflake Inc.

Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/2455

Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

公开(公告)号：US11386059B2

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

申请号：US17463514

申请日：2021-08-31

Applicant: SNOWFLAKE INC.

Inventor： Allison Lee ,  Shrainik Jain ,  Qiuye Jin ,  Stratis Viglas ,  Jiaqi Yan

IPC: G06F16/00 ,  G06F16/21 ,  G06F11/34 ,  G06F11/07 ,  G06F16/215 ,  G06F11/30 ,  G06F16/2453

Abstract: A baseline run of a workload and a target run of the workload are compared to identify whether there is a performance regression in the target run, wherein the target run implements a feature that is not implemented in the baseline run. In response to identifying the performance regression, the target run is executed to identify whether the performance regression still exists. The performance regression is flagged as a false positive in response to identifying that the performance regression no longer exists when the target run is executed.

公开(公告)号：US20220217180A1

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

申请号：US17701482

申请日：2022-03-22

Applicant: Snowflake Inc.

Inventor： James Calvin Armstrong ,  Jonathan Claybaugh

IPC: H04L9/40 ,  G06F21/57 ,  G06F21/62 ,  H04L41/0604 ,  H04L41/22 ,  H04L43/00 ,  H04L43/026 ,  H04L43/062 ,  H04L43/0811 ,  H04L47/10 ,  G06F21/56

Abstract: The disclosure relates generally to methods, systems, and apparatuses for managing network connections. A method may include comparing a list of expected connections among a set of endpoints of a network with one or more of the actual connections indicated by configuration files of the set of endpoints to determine one or more differences between the list of expected connections and the actual connections and updating at least one of the configuration files of the set of endpoints to reflect the one or more differences detected between the list of expected connections and the actual connections.

公开(公告)号：US20220217150A1

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

申请号：US17702115

申请日：2022-03-23

Applicant: SNOWFLAKE INC.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Matthew J. Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

IPC: H04L9/40 ,  H04L51/00 ,  G06F16/2455 ,  H04L41/22 ,  H04L67/1097

Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes generating a plurality of listings in a data exchange. A first listing of the plurality of listings may include a reference to a first version of shared data within a first database, where the first version is one of a plurality of versions of the shared data within the first database. The method further includes receiving a request from a member of the data exchange for access to the first listing and limiting, by a processing device, access for the member to the first version of the shared data of the first database referenced by the first listing.

公开(公告)号：US20220217125A1

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

申请号：US17656620

申请日：2022-03-25

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Robert Bengt Benedikt Gernhardt ,  Martin Hentschel ,  Nithin Mahesh ,  Eric Robinson

IPC: H04L9/40 ,  H04L9/08 ,  G06F16/27 ,  H04L9/30

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.

公开(公告)号：US20220215041A1

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

申请号：US17703804

申请日：2022-03-24

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Eric Robinson ,  Martin Hentschel

IPC: G06F16/27 ,  G06F16/245

Abstract: Replication and failover of database data is disclosed. A method includes copying a first dataset of a first account stored in a primary deployment to a secondary deployment. The method includes determining that the first dataset stored in the primary deployment is unavailable. The method includes executing a first transaction on the first dataset at the secondary deployment in response to determining that the first dataset stored in the primary deployment is unavailable. The method includes executing a second transaction on a second dataset of a second account at the primary deployment while the first dataset of the first account stored in the primary deployment is unavailable.

公开(公告)号：US11379480B1

公开(公告)日：2022-07-05

申请号：US17647629

申请日：2022-01-11

Applicant: Snowflake Inc.

Inventor： Sebastian Breß ,  Moritz Eyssen ,  Max Heimel

IPC: G06F16/245 ,  G06F16/2453

Abstract: Sub-plans are executed in parallel using a plurality of execution nodes, which can be part of a data platform. In particular, sub-plans (e.g., fragments or portions of one or more child operators) of a root operator are identified in a query plan such that the identified sub-plans that are candidates for execution on a single execution node, determine a cost estimate for causing the candidate sub-plans to be executed in parallel using multiple execution nodes, and cause the candidate sub-plans to be executed in parallel based on the cost estimate.

公开(公告)号：US20220207041A1

公开(公告)日：2022-06-30

申请号：US17655124

申请日：2022-03-16

Applicant: Snowflake Inc.

Inventor： Mahmud Allahverdiyev ,  Thierry Cruanes ,  Ismail Oukid ,  Stefan Richter

IPC: G06F16/2455 ,  G06F16/9035 ,  G06F16/28 ,  G06F17/18 ,  G06F16/22

Abstract: A source table organized into a set of batch units is accessed. The source table comprises a column of data corresponding to a semi-structured data type. One or more indexing transformations for an object in the column are generated. The generating of the one or more indexing transformation includes converting the object to one or more stored data types. A pruning index is generated for the source table based in part on the one or more indexing transformations. The pruning index comprises a set of filters that index distinct values in each column of the source table, and each filter corresponds to a batch unit in the set of batch units. The pruning index is stored in a database with an association with the source table.