公开(公告)号：US11704199B1

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

申请号：US17823690

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Sahaj Saini ,  Matthew Uhlar

IPC: G06F16/25 ,  G06F16/27 ,  G06F11/14

CPC classification number: G06F11/1435 ,  G06F16/256 ,  G06F16/27 ,  G06F2201/84

Abstract: This disclosure provides methods and techniques of data replication involving cross replication group (RG) references. The present disclosure avoids automatic replication failing when an entity in an RG refers to another entity external to the RG. The entity to be replicated within the RG is referred to as the “referring entity,” and the entity as the dangling reference is referred to as the “referred entity.” Although the referring and referred entities are not replicated together in a replication operation, the referred entity may have already been replicated to the target account in another replication operation on a different replication group. In such cases, the data replication procedure may, according to aspects of the present disclosure, check if the referred entity has already been replicated, and if so, proceed to replicate the referring entity without fail, and link the referring and referred entities to enable normal functioning of the referring entity.

公开(公告)号：US11704100B2

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

申请号：US17823621

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Siddharth Kulkarni ,  Isaac Kunen

IPC: G06F8/41 ,  G06F21/60 ,  G06F9/54 ,  G06F21/53 ,  G06F16/2455 ,  G06F16/245

CPC classification number: G06F8/44 ,  G06F9/547 ,  G06F16/245 ,  G06F16/2455 ,  G06F21/53 ,  G06F21/602

Abstract: Embodiments described herein provide techniques for in-line compiling of UDFs in other programming languages. These techniques enable faster programming iterations because it allows users to compile directly in the cloud processing system. Moreover, it allows the UDFs to tie into existing libraries. The compiled results are treated as sensitive and handled with appropriate security policies, as with any other user data in the system.

公开(公告)号：US20230222127A1

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

申请号：US18162708

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/2455 ,  G06F16/27 ,  G06F16/242

CPC classification number: G06F16/24565 ,  G06F16/27 ,  G06F16/2443

Abstract: First and second database accounts respectively share first and second source datasets with one another in a data clean room. The first database account stores a first approved-statements table that contains database statements that are permitted by the first database account to be executed against a combination of the shared first source dataset and the shared second source dataset. The second database account stores a second approved-statements table that contains database statements that are permitted by the second database account to be executed against the combination of the shared first source dataset and the shared second source dataset. One or more queries received from the first database account that are included in the second approved-statements table are processed, as are one or more queries received from the second database account that are included in the first approved-statements table.

公开(公告)号：US20230205766A1

公开(公告)日：2023-06-29

申请号：US18179762

申请日：2023-03-07

Applicant: Snowflake Inc.

Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

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

CPC classification number: G06F16/2379 ,  G06F16/2282 ,  G06F16/2456 ,  G06F16/24554

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.

公开(公告)号：US20230205735A1

公开(公告)日：2023-06-29

申请号：US18179793

申请日：2023-03-07

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Eric Robinson

IPC: G06F16/14 ,  G06F16/16

CPC classification number: G06F16/148 ,  G06F16/164

Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.

公开(公告)号：US11687436B2

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

申请号：US17656581

申请日：2022-03-25

Applicant: Snowflake Inc.

Inventor： Christian Kleinerman ,  Christopher F. Pouliot ,  Jacobus J. P. Van Ryswyck

IPC: G06F11/34 ,  G06F11/30

CPC classification number: G06F11/3419 ,  G06F11/3006 ,  G06F11/3075 ,  G06F11/3466

Abstract: Techniques described herein can monitor various data metrics. The auto-insight techniques can further detect and rank data segments that contributed to, or counteracted, shifts in data and detect when such shifts occurred. Thus, the techniques described herein can detect and identify root causes in shifts in different metrics. The techniques include pruning and ranking causes to identify the root causes and identify non-relevant factors, as well.

公开(公告)号：US20230185952A1

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

申请号：US18167950

申请日：2023-02-13

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Thierry Cruanes ,  Istvan Cseri ,  Benoit Dageville ,  Unmesh Jagtap ,  Subramanian Muralidhar

IPC: G06F21/62 ,  G06F9/445 ,  G06Q30/06

CPC classification number: G06F21/6227 ,  G06F9/44505 ,  G06Q30/06 ,  G06F2221/2141

Abstract: Embodiments of the present disclosure enable users of a data sharing system to build native applications that can be shared with other users of the data sharing system. The native applications can be published and discovered in the data sharing system like any other data listing, and consumers can install them in their local data sharing system account to serve their data processing needs. A provider may define an installation script for installing an application and create a share object to which the installation script may be attached. In response to an imported database being created in a consumer account based on the share object, a native application framework may automatically execute the installation script in the consumer account and may create a set of database roles to manage execution of the application in the consumer account.

公开(公告)号：US20230177063A1

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

申请号：US18162522

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Simon A. Field ,  Stuart Ozer

IPC: G06F16/25 ,  G06F16/2455 ,  G06F16/84 ,  G06F16/22

CPC classification number: G06F16/25 ,  G06F16/24558 ,  G06F16/86 ,  G06F16/2282

Abstract: The subject technology receives by a database system, raw input data from a source table provided by an external environment, the source table comprising multiple rows and multiple columns, the raw input data comprising values in a first format, the values comprising input features corresponding to datasets included in the raw input data for machine learning models, the external environment comprising an external system from the database system and is accessed by different users. The subject technology generates cell data for a second table based on the values from the source table. The subject technology performs a database operation to generate the second table including table metadata, column metadata, and the generated cell data.

公开(公告)号：US20230177039A1

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

申请号：US18162513

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

IPC: G06F16/23 ,  G06F16/27 ,  G06F16/245 ,  G06F16/18

CPC classification number: G06F16/2358 ,  G06F16/278 ,  G06F16/2365 ,  G06F16/245 ,  G06F16/2322 ,  G06F16/1865 ,  G06F9/466

Abstract: A method for table data processing includes retrieving, by at least one hardware processor, first table data associated with a first table version from a plurality of partitions of a storage device. The method further includes detecting, by the at least one hardware processor, an executed transaction causing a modification to the first table data resulting in a second table data associated with a second table version. The second table data is modified to include partition metadata. The partition metadata includes table version information with a mapping of the first table version and the second table version to a plurality of transactions associated with generating the first table data and the second table data.

公开(公告)号：US11669630B1

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

申请号：US18051401

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F21/62 ,  G06F21/78 ,  G06F21/60 ,  G06F21/64

CPC classification number: G06F21/6218 ,  G06F21/604 ,  G06F2221/2141

Abstract: A data dictionary generation system utilizes a background service that is programmed to automatically populate and update a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data overall as well as the individual objects included in the listing, such as the individual tables, schemas, views, and functions. To generate the data dictionary, the data dictionary generation system analyzes the shared data to identify objects, identifies a set of data fields associated with each identified object and populates the set of data fields associated with each identified object based on the shared data offered by the listing. To ensure that a data dictionary for each listing remains up to date, the data dictionary generation system periodically scans the listings to identify any changes to share access granted to the listings.