公开(公告)号：US20230315700A1

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

申请号：US17971482

申请日：2022-10-21

Applicant: Snowflake Inc.

Inventor： Ganeshan Ramachandran Iyer ,  Raghav Ramachandran ,  Subramanian Muralidhar

IPC: G06F16/215 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/2457

CPC classification number: G06F16/215 ,  G06F16/248 ,  G06F16/24552 ,  G06F16/24573

Abstract: Embodiments of the present disclosure provide techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein the data exchange includes a metadata storage where metadata including a list of files ingested is stored. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested into the data exchange, the set of bloom filters may be used to identify from within the set of candidate files, each candidate file that is duplicative of a file in the first set of files.

公开(公告)号：US11775669B1

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

申请号：US18060476

申请日：2022-11-30

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Mohamad Raja Gani Mohamad Abdul ,  William A. Pugh

IPC: G06F21/62

CPC classification number: G06F21/6218 ,  G06F21/629

Abstract: A data platform for developing and deploying a data application. The data platform receives from a first user the data application and provider granted privileges including a consumer usage privilege and a consumer access to data privilege. The data platform authorizes the second user to access the data platform based on one or more consumer account privileges included in a set of account privileges. The data platform authorizes the second user to execute the data application based on the consumer usage privilege. During execution, the data platform authorizes the data application to access the provider database object based on the consumer access to data privilege, and authorizes the data application to access the consumer database object based on a provider access to data privilege provided by the second user.

公开(公告)号：US20230305910A1

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

申请号：US18326905

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Isaac Kunen ,  Srinath Shankar ,  Zhihan Li ,  Khushboo Bhatia ,  Edward Ma

IPC: G06F9/54 ,  G06F16/2455 ,  G06F16/28 ,  G06F21/53

CPC classification number: G06F9/547 ,  G06F16/2455 ,  G06F16/289 ,  G06F21/53

Abstract: Methods, systems, and computer programs are presented for providing stored procedures stored within a database to invoke specified functionality in a cloud data platform. A response to a database query is received at a compute node of a cloud data platform. A java database connectivity (JDBC) instance executing within a sandbox process converts the response into a remote procedure call. The remote procedure call is provided to a stored procedure executing within the sandbox process as the response to the database query.

公开(公告)号：US20230297579A1

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

申请号：US18324710

申请日：2023-05-26

Applicant: Snowflake Inc.

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

IPC: 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.

公开(公告)号：US11755617B2

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

申请号：US17501833

申请日：2021-10-14

Applicant: Snowflake Inc.

Inventor： Ashish Motivala ,  Benoit Dageville

IPC: G06F16/00 ,  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 ,  G06F16/28 ,  G06F16/25 ,  A61F5/56 ,  G06F9/48 ,  H04L67/1095 ,  H04L67/1097

CPC classification number: G06F16/27 ,  A61F5/566 ,  G06F9/4881 ,  G06F9/5016 ,  G06F9/5044 ,  G06F9/5083 ,  G06F9/5088 ,  G06F16/148 ,  G06F16/1827 ,  G06F16/211 ,  G06F16/221 ,  G06F16/2365 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/24532 ,  G06F16/24545 ,  G06F16/24552 ,  G06F16/254 ,  G06F16/283 ,  G06F16/951 ,  G06F16/9535 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/568

Abstract: Example systems and methods for cloning catalog objects are described. In one implementation, a method includes creating a copy of a catalog object without copying a data associated with the catalog object by only coping metadata associated with the object. The method further includes modifying, by one or more processors, the data associated with the catalog object independently of the copy of the catalog object.

公开(公告)号：US11748374B2

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

申请号：US17457751

申请日：2021-12-06

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Laxman Mamidi ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini

IPC: G06F16/00 ,  G06F16/27 ,  G06F11/14 ,  G06F16/25 ,  G06F11/20 ,  G06F16/182 ,  G06F16/13 ,  G06F16/178 ,  G06F16/11

CPC classification number: G06F16/27 ,  G06F11/1461 ,  G06F11/1464 ,  G06F11/2023 ,  G06F11/2097 ,  G06F16/128 ,  G06F16/137 ,  G06F16/1787 ,  G06F16/184 ,  G06F16/1827 ,  G06F16/1844 ,  G06F16/256

Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.

公开(公告)号：US11748155B1

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

申请号：US17659925

申请日：2022-04-20

Applicant: Snowflake Inc.

Inventor： Yuchen Cao ,  Stephen Mark Andrew Clark ,  Supriya Vasudevan ,  Jinzhou Yang

IPC: G06F9/48 ,  G06F8/41 ,  G06F8/30

CPC classification number: G06F9/4881 ,  G06F8/41 ,  G06F8/311

Abstract: Provided herein are systems and methods for processing a script file generated using a declarative engine for workloads (DEW). A system includes at least one hardware processor coupled to a memory and configured to retrieve a script file. The script file specifies a plurality of tasks forming a plan and an order of execution for the plurality of tasks. The script file is compiled to generate compiled code. The compiled code is executed to generate an in-memory representation of the plan. The in-memory representation of the plan is converted into a graph such as a directed acyclic graph (DAG). The graph includes the plurality of tasks. The plurality of tasks in the graph are executed according to the order of execution.

公开(公告)号：US20230273918A1

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

申请号：US18051483

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Srilakshmi Chintala ,  Chong Han ,  Albert L. Hu ,  Nitya Kumar Sharma ,  Igor Zinkovsky

IPC: G06F16/242 ,  G06F16/248 ,  G06F16/27 ,  G06F8/41

CPC classification number: G06F16/2448 ,  G06F16/248 ,  G06F16/27 ,  G06F8/433

Abstract: A database dependency resolver system can identify different dependencies of a user application and integrate the identified dependencies in different execution environments of a distributed database system. The different execution environments can manage different versions of a given programming language, or other types of computational architectures (e.g., different CPU types). A database user can provide a database statement (e.g., query) that activates the different dependencies in the different environments to generate results data.

公开(公告)号：US11734307B2

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

申请号：US17124240

申请日：2020-12-16

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Thierry Cruanes ,  Marcin Zukowski

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

CPC classification number: G06F16/27 ,  A61F5/566 ,  G06F9/4881 ,  G06F9/5016 ,  G06F9/5044 ,  G06F9/5083 ,  G06F9/5088 ,  G06F16/148 ,  G06F16/1827 ,  G06F16/211 ,  G06F16/221 ,  G06F16/2365 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/24532 ,  G06F16/24545 ,  G06F16/24552 ,  G06F16/254 ,  G06F16/283 ,  G06F16/951 ,  G06F16/9535 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/568

Abstract: Caching systems and methods are described. In one implementation, a method identifies multiple files used to process a query and distributes each of the multiple files to a particular execution node to execute the query. Each execution node determines whether the distributed file is stored in the execution node's cache. If the execution node determines that the file is stored in the cache, it processes the query using the cached file. If the file is not stored in the cache, the execution node retrieves the file from a remote storage device, stores the file in the execution node's cache, and processes the query using the file.

公开(公告)号：US11734303B2

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

申请号：US16805632

申请日：2020-02-28

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Marcin Zukowski

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

CPC classification number: G06F16/27 ,  A61F5/566 ,  G06F9/4881 ,  G06F9/5016 ,  G06F9/5044 ,  G06F9/5083 ,  G06F9/5088 ,  G06F16/148 ,  G06F16/1827 ,  G06F16/211 ,  G06F16/221 ,  G06F16/2365 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/24532 ,  G06F16/24545 ,  G06F16/24552 ,  G06F16/254 ,  G06F16/283 ,  G06F16/951 ,  G06F16/9535 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/568

Abstract: Example caching systems and methods are described. In one implementation, a method identifies multiple files used to process a query and distributes each of the multiple files to a particular execution node to execute the query. Each execution node determines whether the distributed file is stored in the execution node's cache. If the execution node determines that the file is stored in the cache, it processes the query using the cached file. If the file is not stored in the cache, the execution node retrieves the file from a remote storage device, stores the file in the execution node's cache, and processes the query using the file.