公开(公告)号：US11514022B2

公开(公告)日：2022-11-29

申请号：US17364772

申请日：2021-06-30

Applicant: Snowflake Inc.

Inventor： Istvan Cseri ,  Dinesh Chandrakant Kulkarni

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/2457 ,  G06F16/17 ,  G06F16/18 ,  G06F16/16 ,  G06F16/22 ,  G06F16/182

Abstract: A database platform can track changes using a stream that records changes made by database transactions. Streams on views can be implemented by applying a stream to source data, and applying the view to the streamed data. Users of the database platform can query the stream on the view to review recent changes to the view, such as changes made since the last database transaction.

公开(公告)号：US11500900B2

公开(公告)日：2022-11-15

申请号：US17568542

申请日：2022-01-04

Applicant: SNOWFLAKE INC.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Marcin Zukowski

IPC: G06F16/27 ,  G06F16/182 ,  G06F9/50 ,  G06F16/14 ,  G06F16/21 ,  G06F16/22 ,  G06F16/951 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/9535 ,  G06F16/2453 ,  H04L67/568 ,  A61F5/56 ,  G06F9/48 ,  H04L67/1095 ,  H04L67/1097

Abstract: A method and apparatus managing a set of processors for a set of queries is described. In an exemplary embodiment, a device receives a set of queries for a data warehouse, the set of queries including one or more queries to be processed by the data warehouse. The device further provisions a set of processors from a first plurality of processors, where the set of processors to process the set of queries, and a set of storage resources to store data for the set of queries. In addition, the device monitors a utilization of the set of processors as the set of processors processes the set of queries. The device additionally updates a number of the processors in the set of processors provisioned based on the utilization. Furthermore, the device processes the set of queries using the updated set of processors.

公开(公告)号：US20220358139A1

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

申请号：US17873359

申请日：2022-07-26

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Thierry Cruanes ,  Marcin Zukowski

IPC: G06F16/27 ,  G06F9/50 ,  G06F16/14 ,  G06F16/21 ,  G06F16/22 ,  G06F16/951 ,  G06F16/182 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/9535 ,  G06F16/2453 ,  H04L67/568 ,  A61F5/56 ,  G06F9/48 ,  H04L67/1095 ,  H04L67/1097

Abstract: Example resource management systems and methods are described. In one implementation, a system includes a memory and a processing device operatively coupled to the memory. The processing device is to: provide a plurality of execution nodes, each execution node comprising a cache and a processor, each execution node communicatively coupled to a storage platform; determine at least one task associated with processing a received query referencing database data stored in the storage platform; and create a new execution node within the plurality of execution nodes to process the at least one task associated with processing the received query.

公开(公告)号：US20220358128A1

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

申请号：US17814110

申请日：2022-07-21

Applicant: Snowflake Inc.

Inventor： Mahmud Allahverdiyev ,  Selcuk Aya ,  Bowei Chen ,  Ismail Oukid

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

Abstract: A pruning index is generated for a source table organized into a set of batch units. The source table comprises a column of semi-structured data. The pruning index comprises a set of filters that index distinct values in each column of the source table. Rather than reassembling an entire tree structure of the semi-structured data prior to indexing, the generating of the pruning index comprises traversing a reassembly hook object that represents a first portion of the semi-structured data that is subcolumnarized and traversing a residual object that represents a second portion of the semi-structured data that is not subcolumnarized. The reassembly hook object is traversed to identify values corresponding to the first portion of the semi-structured data and the residual object is traversed to identify values corresponding to the second portion. The pruning index is stored with an association with the source table.

公开(公告)号：US11496524B2

公开(公告)日：2022-11-08

申请号：US17701482

申请日：2022-03-22

Applicant: Snowflake Inc.

Inventor： James Calvin Armstrong ,  Jonathan Claybaugh

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

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.

公开(公告)号：US11494500B1

公开(公告)日：2022-11-08

申请号：US17655887

申请日：2022-03-22

Applicant: Snowflake Inc.

Inventor： Suraj P. Acharya ,  Damien Carru ,  Vikas Jain ,  Zhen Mo ,  Frantisek Rolinek

IPC: G06F21/00 ,  G06F21/60 ,  G06F16/27 ,  G06F21/62

Abstract: A request to replicate a first account maintained by a data platform is received. Based on the request, account data associated with the account is accessed. The account data comprises security configurations for the first account. In response to the request, the first account is replicated using the account data. A second account results from replicating the first account. The replicating of the first account comprises automatically replicating the security configurations for the first account to the second account. The replicating of the security configurations comprises replicating an identity management configuration of the first account; replicating an authorization configuration of the first account; and replicating an authentication configuration of the first account.

公开(公告)号：US11494386B2

公开(公告)日：2022-11-08

申请号：US17646905

申请日：2022-01-04

Applicant: Snowflake Inc.

Inventor： Bing Li ,  Edward Ma ,  Mingli Rui ,  Haowei Yu ,  Andong Zhan

IPC: G06F17/30 ,  G06F16/2455 ,  G06F16/25 ,  G06F21/62 ,  G06F16/28 ,  G06F16/27 ,  H04L9/40

Abstract: A shared database platform can interface with a cluster computing platform over a network through a connector. The data transferred over the network can include metadata result packages that can be distributed to worker nodes of the cluster computing platform, which receive the metadata objects and access the result data for further processing on a staging platform, such as a scalable storage platform.

公开(公告)号：US20220353329A1

公开(公告)日：2022-11-03

申请号：US17245960

申请日：2021-04-30

Applicant: Snowflake Inc.

Inventor： Edmond T. CHAN ,  Pui Kei Johnston CHU ,  Chao REN ,  Stephanie STILLMAN ,  Dangfu WANG

IPC: H04L29/08 ,  G06F16/21

Abstract: Provided herein are systems and methods to provide a way to share metrics regarding shared data access and accesses associated with data providers for different data listings of the data exchange. For example, the method may comprise detecting one or more client interactions with a set of data listings of a data exchange, the set of data listings associated with one or data providers. The method may further comprise collecting metrics corresponding to the one or more client interactions. In addition, the method may share metrics relevant to the one or more data providers with the one or more data providers.

公开(公告)号：US20220350880A1

公开(公告)日：2022-11-03

申请号：US17326646

申请日：2021-05-21

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Ganeshan Ramachandran Iyer ,  Isaac Kunen

IPC: G06F21/54 ,  G06F16/2455 ,  G06F21/53 ,  G06F21/60

Abstract: The logging techniques described herein can enable using logging tools without having to use different methods for sandbox implementations and push out the log data to storage without problems. The log data is treated as sensitive data and is protected according to the defined security policies. Further, the results may be compressed and encrypted.

公开(公告)号：US11487870B1

公开(公告)日：2022-11-01

申请号：US17326646

申请日：2021-05-21

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Ganeshan Ramachandran Iyer ,  Isaac Kunen

IPC: G06F21/54 ,  G06F16/2455 ,  G06F21/60 ,  G06F21/53

Abstract: The logging techniques described herein can enable using logging tools without having to use different methods for sandbox implementations and push out the log data to storage without problems. The log data is treated as sensitive data and is protected according to the defined security policies. Further, the results may be compressed and encrypted.