公开(公告)号：US11734116B1

公开(公告)日：2023-08-22

申请号：US18060848

申请日：2022-12-01

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Yan Huang ,  Jaeha Lee ,  Shiyu Qu ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F16/21 ,  G06F11/34

CPC classification number: G06F11/1433 ,  G06F11/3414 ,  G06F16/213 ,  G06F2201/80

Abstract: Provided herein are systems and methods for automating the rollout of database changes. For example, a method includes detecting a change in database code of a database resulting in a changed database code. The change in the database code includes a parameter rollout for at least one parameter setting of the database. Execution of a query associated with the change in the database code is monitored. The query uses the at least one parameter setting. A regression in the changed database code is detected based on the monitoring. Impact analysis is performed to determine a scope of impact of the regression on at least another query using the at least one parameter setting. A determination is made on whether to perform a rollback of the change in the database code or perform mitigation based on the scope of impact.

公开(公告)号：US20230259530A1

公开(公告)日：2023-08-17

申请号：US18139809

申请日：2023-04-26

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Florian Andreas Funke ,  Peter Povinec

IPC: G06F16/28 ,  H04L67/1008 ,  H04L41/5025 ,  G06F16/2455 ,  G06F9/50 ,  H04L67/1097 ,  H04L41/0896

CPC classification number: G06F16/283 ,  H04L67/1008 ,  H04L41/5025 ,  G06F16/2455 ,  G06F9/5072 ,  H04L67/1097 ,  H04L41/0896 ,  H04L43/0817

Abstract: A method implementing a fault-tolerant data warehouse using availability zones includes allocating a plurality of processing units to a data warehouse, the processing units located in different availability zones, an availability zone comprising one or more data centers. The method further includes routing a query to a processing unit within the data warehouse, the query having a common session identifier with a query previously provided to the processing unit, the processing unit determined to be caching a data segment associated with a cloud storage resource independent of the plurality of processing units. The method further includes, as a result of monitoring a number of queries running at an input degree of parallelism, determining that the processing capacity of the processing units has reached a threshold; and changing a total number of processing units using the input degree of parallelism and the number of queries.

公开(公告)号：US11727136B2

公开(公告)日：2023-08-15

申请号：US17697744

申请日：2022-03-17

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Thierry Cruanes ,  Martin Hentschel ,  Peter Povinec

IPC: G06F21/62 ,  G06F16/25

CPC classification number: G06F21/6218 ,  G06F16/256 ,  G06F2221/2145

Abstract: A method of sharing data in a multi-tenant database includes inspecting, by a processing device of a multiple tenant database, a sharer account to determine a presence of a grant to a second role object, in a target account, of access rights to a first role object included in the sharer account. The method includes granting the second role object, in the target account, access rights to an alias object. The first role object having one or more grants to the one or more resources of the sharer account. The target account accesses the one or more resources using the one or more grants of the first role object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.

公开(公告)号：US11727013B2

公开(公告)日：2023-08-15

申请号：US17930150

申请日：2022-09-07

Applicant: Snowflake Inc.

Inventor： Tyler Arthur Akidau ,  Thierry Cruanes ,  Istvan Cseri ,  Benoit Dageville ,  Tyler Jones ,  Dinesh Chandrakant Kulkarni

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

CPC classification number: G06F16/24568 ,  G06F16/24544

Abstract: Hybrid tables can be used in different use-case scenarios. Hybrid tables provide a flexible mechanism to support files and data in different formats while providing access to the different types of data as part of one table. This flexibility can allow the use of hybrid tables in data lake or other similar environments.

公开(公告)号：US20230252189A1

公开(公告)日：2023-08-10

申请号：US18161574

申请日：2023-01-30

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Khalid Zaman Bijon ,  Subramanian Muralidhar ,  David Schultz

IPC: G06F21/62 ,  G06F16/28 ,  G06F16/245

CPC classification number: G06F21/6254 ,  G06F16/284 ,  G06F16/245

Abstract: Various embodiments provide for tag-based application of a masking policy, which can be used in connection with a data platform. In particular, various embodiments enable enforcement of one or more masking policies against an entity (e.g., object) of a data platform, such as a database, a table, a row, or a column, based on one or more tags associated with the entity.

公开(公告)号：US20230252039A1

公开(公告)日：2023-08-10

申请号：US18302515

申请日：2023-04-18

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Ganeshan Ramachandran Iyer ,  Unmesh Jagtap ,  Subramanian Muralidhar

IPC: G06F16/25 ,  G06F16/22

CPC classification number: G06F16/254 ,  G06F16/2282 ,  G06F16/258

Abstract: Techniques for configuring event tables include retrieving, by at least one hardware processor of a computing node, log data at a first process of the computing node. The log data is associated with a function executing at a second process of the computing node. The log data is revised using a table stage to generate revised log data. The table stage is configured as a dedicated storage location of the first process. The revising includes a data enrichment process based on metadata associated with execution of the function at the second process. The revised log data is ingested into an event table.

公开(公告)号：US20230237043A1

公开(公告)日：2023-07-27

申请号：US18158627

申请日：2023-01-24

Applicant: Snowflake Inc.

Inventor： Tyler Arthur Akidau ,  Istvan Cseri ,  Fabian Hueske ,  Tyler Jones ,  Yevgeniy Kogan ,  Dzmitry Pauliukevich ,  Daniel E. Sotolongo

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

CPC classification number: G06F16/2358 ,  G06F16/2282 ,  G06F16/2456

Abstract: Techniques described herein can accelerate change data capture determinations such as stream reads, which show changes made to a table between two points in time. Three distinct row bitests that mark deleted, updated, inserted, rows in micro-partitions can be added as metadata for the table. These bitsets can be generated during DML operations and then stored as metadata of the new partition generated by the DML operations. The bitsets can then be used to generate streams showing the changes in the table between two points in time (changes interval).

公开(公告)号：US11709837B2

公开(公告)日：2023-07-25

申请号：US17334339

申请日：2021-05-28

Applicant: Snowflake Inc.

Inventor： Matthias Carl Adams ,  Simon Holm Jensen ,  Spyridon Triantafyllis

IPC: G06F16/00 ,  G06F7/00 ,  G06F16/2453

CPC classification number: G06F16/24544 ,  G06F16/24537

Abstract: Disclosed herein are systems and methods for performing a geospatial-function join using an implied interval join. In an embodiment, a database platform receives a query that includes a geospatial-function join, which applies a geospatial-function predicate to a first geography data object of a first relation and a second geography data object of a second relation. The database platform processes the first and second relations through an interval join that applies an interval-join predicate that is implied by the geospatial-function predicate. The database platform obtains query results at least in part by implementing a filter that applies the geospatial-function predicate to an output of the interval join, and outputs the query results.

公开(公告)号：US11704338B1

公开(公告)日：2023-07-18

申请号：US17652721

申请日：2022-02-28

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/30 ,  G06F16/27 ,  G06F16/25 ,  G06F16/21

CPC classification number: G06F16/27 ,  G06F16/213 ,  G06F16/256

Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.

公开(公告)号：US11704306B2

公开(公告)日：2023-07-18

申请号：US17150593

申请日：2021-01-15

Applicant: Snowflake Inc.

Inventor： Marcin Zukowski

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

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.