公开(公告)号：US20240070148A1

公开(公告)日：2024-02-29

申请号：US18503523

申请日：2023-11-07

Applicant: Snowflake Inc.

Inventor： Marcin Zukowski

IPC: G06F16/23 ,  G06F16/21 ,  G06F16/242 ,  G06F16/2457 ,  G06F21/62

CPC classification number: G06F16/2393 ,  G06F16/21 ,  G06F16/2445 ,  G06F16/24573 ,  G06F21/6227

Abstract: A restricted view definition is received by a database system. The restricted view definition defines a view over a database table with one or more restrictions on use of the view. The view over the database table is generated based on the restricted view definition. A query directed at the view is received by the database system. The database system determines whether the query directed at the view is permitted based on the one or more restrictions on the use of the view.

公开(公告)号：US11907212B1

公开(公告)日：2024-02-20

申请号：US18194357

申请日：2023-03-31

Applicant: Snowflake Inc.

Inventor： Tyson J. Hamilton ,  Qinye Li ,  Steven Parkes ,  Xie Xu

IPC: G06F16/00 ,  G06F16/242 ,  G06F16/23 ,  G06F16/248 ,  G06F9/54

CPC classification number: G06F16/2448 ,  G06F16/2365 ,  G06F16/248 ,  G06F9/54

Abstract: Provided herein are systems and methods for configuring trace events. A system includes at least one hardware processor coupled to a memory and configured to instantiate a user code runtime to execute user-defined function (UDF) code. The user code runtime is instantiated within a sandbox process of an execution node. An application programming interface (API) call is detected during execution of the UDF code. The API call includes one or more configurations of a trace event. Telemetry information is collected based on the one or more configurations. The telemetry information is associated with the trace event using a telemetry API. The telemetry API corresponds to the API call. The telemetry information is formatted using the telemetry API, to generate structured telemetry information. The at least one hardware processor causes ingestion of the structured telemetry information into an event table.

公开(公告)号：US20240056378A1

公开(公告)日：2024-02-15

申请号：US18492771

申请日：2023-10-23

Applicant: Snowflake Inc.

Inventor： Jonathan C. Allie ,  Seth Hettich ,  Aaron S. Joyner

IPC: H04L43/50 ,  H04L43/0805 ,  H04L43/0817 ,  H04L67/133 ,  H04L61/4541 ,  H04L67/02 ,  H04L67/1036 ,  H04L61/4511

CPC classification number: H04L43/50 ,  H04L43/0805 ,  H04L43/0817 ,  H04L67/133 ,  H04L61/4541 ,  H04L67/02 ,  H04L67/1036 ,  H04L61/4511

Abstract: A system may include a processing device and a memory storing instructions that, when executed by the processing device, causes the processing device to obtain a health check instruction that is specific to a name of a service that is associated with one or more endpoints, including performing a lookup with the name to obtain the health check instruction that is specific to the name. The processing device performs the one or more actions of the health check instruction to determine a health status of the one or more endpoints, and stores the health status of the one or more endpoints. In response to receiving a request to resolve the name from a client, the processing device returns the one or more endpoints based at least on the health status of the one or more endpoints.

公开(公告)号：US11893025B2

公开(公告)日：2024-02-06

申请号：US18047595

申请日：2022-10-18

Applicant: Snowflake Inc.

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

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

CPC classification number: G06F16/24557 ,  G06F16/2272 ,  G06F16/283 ,  G06F16/9035 ,  G06F17/18

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.

公开(公告)号：US11880388B2

公开(公告)日：2024-01-23

申请号：US18171292

申请日：2023-02-17

Applicant: Snowflake Inc.

Inventor： Nikolaos Romanos Katsipoulakis ,  Dimitrios Tsirogiannis ,  Zhaohui Zhang

IPC: G06F17/30 ,  G06F16/28 ,  G06F16/22

CPC classification number: G06F16/283 ,  G06F16/2264 ,  G06F16/284

Abstract: The subject technology receives, from a metadata database, information related to a base table. The subject technology determines a table object associated with the base table, the table object including a first set of metadata. The subject technology generates a nested object based on a second set of metadata, the second set of metadata including information linking the nested object to the table object. The subject technology generates a second table object associated with the nested object, the second table object representing a secondary index of the base table, the second table object including information linking the second table object to the nested object. The subject technology establishes a link between the second table object to the base table based on the nested object. The subject technology stores, in the metadata database, the nested object and the second table object.

公开(公告)号：US11880369B1

公开(公告)日：2024-01-23

申请号：US18057563

申请日：2022-11-21

Applicant: Snowflake Inc.

Inventor： Max Heimel ,  Ismail Oukid ,  Linnea Passing ,  Stefan Richter ,  Juliane K. Waack

IPC: G06F16/2455 ,  G06F16/2457

CPC classification number: G06F16/24557 ,  G06F16/24578

Abstract: A top K query directed at a table is received. The table is organized into multiple storage units. The top K query comprises a first clause to sort a result set in order and a second clause that specifies a limit on a number of results provided in response to the query. A table scan operator identifies a first set of rows from the table based on a scan set determined for the table and provides the first set of rows to a top K operator. The top K operator determines a current boundary based on the first set of rows and provides the current boundary to the table scan operator. The table scan operator prunes the scan set based on the current boundary and identifies a second set of rows from the table based on the pruning.

公开(公告)号：US11880364B2

公开(公告)日：2024-01-23

申请号：US17157233

申请日：2021-01-25

Applicant: Snowflake Inc.

Inventor： Qiming Jiang ,  Orestis Kostakis

IPC: G06F16/2453 ,  G06F16/2455 ,  G06N20/00

CPC classification number: G06F16/24542 ,  G06F16/2455 ,  G06N20/00

Abstract: The subject technology receives a query directed to a set of source tables, each source table organized into a set of micro-partitions. The subject technology determines a set of metadata, the set of metadata comprising table metadata, query metadata, and historical data related to the query. The subject technology predicts, using a machine learning model, an indicator of an amount of computing resources for executing the query based at least in part on the set of metadata. The subject technology generates a query plan for executing the query based at least in part on the predicted indicator of the amount of computing resources. The subject technology executes the query based at least in part on the query plan.

公开(公告)号：US11876802B2

公开(公告)日：2024-01-16

申请号：US18054621

申请日：2022-11-11

Applicant: Snowflake Inc.

Inventor： Polita Paulus ,  Peter Povinec ,  Saurin Shah ,  Srinidhi Karthik Bisthavalli Srinivasa

IPC: H04L9/40 ,  G06F16/25

CPC classification number: H04L63/0884 ,  G06F16/254 ,  H04L63/107 ,  H04L63/126 ,  H04L2463/081

Abstract: A command to load or unload data at a storage location is received. In response to the command, a storage integration object associated with the storage location is identified. The storage integration object identifies a cloud identity object that corresponds to a cloud identity that is associated with a proxy identity object corresponding to a proxy identity granted permission to access the storage location. The data is loaded or unloaded at the storage location by assuming the proxy identity.

公开(公告)号：US20240012819A1

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

申请号：US18471001

申请日：2023-09-20

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Srilakshmi Chintala ,  Istvan Cseri ,  Rodger N. Kline ,  Nitya Kumar Sharma ,  Igor Zinkovsky

IPC: G06F16/2455 ,  G06F16/25 ,  G06F16/27

CPC classification number: G06F16/24564 ,  G06F16/258 ,  G06F16/27

Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.

公开(公告)号：US11870895B1

公开(公告)日：2024-01-09

申请号：US18320152

申请日：2023-05-18

Applicant: Snowflake Inc.

Inventor： Dmitry Basavin ,  Aaron S. Joyner ,  Kyle Leonhard

IPC: H04L9/08

CPC classification number: H04L9/0861 ,  H04L9/0819 ,  H04L9/0894

Abstract: A data platform provides for encryption of secrets. During operation, an application of the data platform receives a secret and communicates the secret to an encryption client of the data platform. The encryption client generates an encrypted secret using a Data Encryption Key (DEK) and the secret. The encryption client communicates the DEK to an encryption server of the data platform while retaining the encrypted secret. The encryption server generates an encrypted DEK using a Transit Encryption Key TEK. The encryption server communicates the encrypted DEK to the encryption client and the encryption client generates a binary large object (blob) using the retained encrypted secret and the encrypted DEK. The application stores the blob on a data storage device.