公开(公告)号：US20230055052A1

公开(公告)日：2023-02-23

申请号：US18048248

申请日：2022-10-20

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. An example method includes receiving one or more messages from a plurality of computing devices connected through a network, the one or more messages indicating actual connections among the plurality of computing devices. The example method further includes comparing, by one or more processors, the actual connections to a list of expected connections indicated by a connections master file that comprises connection information for the plurality of computing devices. The method further includes, responsive to detecting one or more differences between the list of expected connections and the actual connections, providing a notification indicating the one or more differences to a log file or a notification area of a user interface.

公开(公告)号：US11586515B1

公开(公告)日：2023-02-21

申请号：US17663941

申请日：2022-05-18

Applicant: Snowflake Inc.

Inventor： Abdullah Al Mahmood ,  Ruta Dhaneshwar ,  Xin Huang ,  Ganeshan Ramachandran Iyer ,  Jiaxing Liang ,  Nithin Mahesh ,  Raghav Ramachandran ,  Purav B. Saraiya ,  Yanyi Zhang

IPC: A61N1/00 ,  G06F11/20 ,  G06F16/27 ,  G06F11/14

Abstract: Described herein are techniques for improving disaster recovery, in particular disaster recovery pertaining to data transfer requests. The data transfer request can be received by each of multiple deployments; however, only a primary deployment can process the request. The data transferred by the primary deployment may be replicated in the secondary deployments. In response to a failover event, one of the secondary deployments can be designated as the new primary development and continue the data transfer based on the data transfer request and the replication information received from the old primary deployment prior to the failover.

公开(公告)号：US20230042949A1

公开(公告)日：2023-02-09

申请号：US17972003

申请日：2022-10-24

Applicant: SNOWFLAKE INC.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Allison Waingold Lee

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: A system and method for managing data storage and data access with querying data in a distributed system without buffering the results of intermediate operations in persistent storage. The method includes pushing, by a first operator, as a result of executing a query plan, an intermediate result to a plurality of secondary operators. Processing of the intermediate result by the plurality of secondary operators is delayed to coordinate generation of a plurality of second results based on beginning a final consumption operation of the plurality of second results.

公开(公告)号：US20230030636A1

公开(公告)日：2023-02-02

申请号：US17823877

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Ata E. Husain Bohra ,  Daniel Geoffrey Karp

IPC: G06F11/14 ,  G06F9/50 ,  G06F16/25 ,  G06F16/245

Abstract: The subject technology retrieves information related to a set of instances of compute service managers, each instance of a particular compute service manager being associated with a set of virtual warehouses. The subject technology filters the information to determine a set of candidates from the set of instances of compute service managers. The subject technology sorts the set of candidates based at least in part on each workload of each of the set of candidates. The subject technology selects a candidate compute service manager from the set of instances of compute service managers to issue a query restart by randomly selecting an execution node, the execution node being included in a particular virtual warehouse associated with the candidate compute service manager, the selecting facilitating improving utilization of cluster resources and improving query execution on the selected candidate compute service manager.

公开(公告)号：US11568079B2

公开(公告)日：2023-01-31

申请号：US17900759

申请日：2022-08-31

Applicant: SNOWFLAKE INC.

Inventor： Justin Langseth ,  Matthew J. Glickman ,  Christian Kleinerman ,  Robert Muglia ,  Daniel Freundel ,  Thierry Cruanes ,  Allison Waingold Lee

IPC: G06F21/00 ,  G06F21/62 ,  H04L9/32 ,  G06F16/2455

Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method creates a secure view of datapoints of a consumer account and processes, using a secure user defined function (UDF), the datapoints of the consumer account and datapoints of a provider account to generate a secure join key. The secure UDF returns a count of matching data points between the consumer account and the provider account, and the method provides the count of matching data points to the consumer account.

公开(公告)号：US11567939B2

公开(公告)日：2023-01-31

申请号：US17814110

申请日：2022-07-21

Applicant: Snowflake Inc.

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

IPC: G06F16/24 ,  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.

公开(公告)号：US20230022027A1

公开(公告)日：2023-01-26

申请号：US17936681

申请日：2022-09-29

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Khalid Zaman Bijon ,  Zheng Mi ,  Subramanian Muralidhar ,  David Schultz ,  Jian Xu

IPC: G06F21/62 ,  G06F21/60 ,  G06F16/22

Abstract: Row-level security (RLS) may provide fine-grained access control based on flexible, user-defined access policies to databases, tables, objects, and other data structures. A RLS policy may be an entity or object that defines rules for row access. A RLS policy may be decoupled or independent from any specific table. This allows more robust and flexible control. A RLS policy may then be attached to one or more tables. The RLS policy may include a Boolean-valued expression.

公开(公告)号：US11544399B2

公开(公告)日：2023-01-03

申请号：US17657578

申请日：2022-03-31

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Khalid Zaman Bijon ,  Peter Povinec

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

Abstract: Using container-centric managed access, an administrator is enabled to define a set of future grants for each object that will be created in the future in a container managed by the administrator. When a user creates a database object, the system checks the future grants to determine if any apply to the user, the database object, or the combination. Any applicable future grants are applied to the database object before the user is allowed to modify it. As a result, the administrator is enabled to control the privileges associated with the database object even before the database object is created, while restricting individual object owners from managing privileges on their owned objects.

公开(公告)号：US11544263B2

公开(公告)日：2023-01-03

申请号：US17657468

申请日：2022-03-31

Applicant: Snowflake Inc.

Inventor： Sangyong Hwang ,  Sourav Sikdar ,  Li Yan

IPC: G06F16/245 ,  G06F16/2453 ,  G06F11/34 ,  G06F16/2455

Abstract: The subject technology receives a first query plan corresponding to a first query, the first query plan comprising a new query plan different than a previous query plan for the first query. The subject technology determines a value indicating an estimated improvement in execution time of the first query plan in comparison to a previous execution time of the previous query plan. The subject technology, in response to determining that the value is greater than a threshold value, attempting to execute the first query using the first query plan, the attempting comprising determining that a second query plan selected among a plurality of query plans has a second estimated execution time that is less than an estimated execution time of the first query plan, and executing the first query at a subsequent time using the second query plan.

公开(公告)号：US11544224B2

公开(公告)日：2023-01-03

申请号：US17657401

申请日：2022-03-31

Applicant: Snowflake Inc.

Inventor： Tyler Jones ,  Peter Povinec

IPC: G06F16/20 ,  G06F16/17 ,  G06F16/18 ,  G06F16/14 ,  H04L67/14 ,  H04L67/01

Abstract: Disclosed herein are systems and methods for attachable-and-detachable database sessions. In an embodiment, a database platform receives an attachment request from a client during a connection-specific database session that is set as a current database session for the client at the database platform, requesting that the client attach to an attachable-and-detachable database session that is maintained in data storage by the database platform. The database platform sets, in response to receiving the attachment request, the attachable-and-detachable database session as the current database session for the client at the database platform. The database platform determines that the client has detached from the attachable-and-detachable database session, and continues to maintain the attachable-and-detachable database session in the data storage.