-
公开(公告)号:US11869051B2
公开(公告)日:2024-01-09
申请号:US17710598
申请日:2022-03-31
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Sameer Deshpande , Eric Dorf , Subramanian Muralidhar , Chao Ren , Dangfu Wang
CPC classification number: G06Q30/04 , G06F9/547 , G06F16/256 , G06Q20/145
Abstract: Embodiments of the present disclosure describe techniques for monitoring usage of data listings and pricing data listings based thereon. Metadata comprising a pricing plan may be added to a data listing to generate a monetized data listing. The monetized data listing may be imported to the consumer account. The usage data of the monetized data listing and listing data of the monetized data listing may be exported to a data warehousing and analysis module. A usage level for a set of jobs processed using the monetized data listing during a current incremental interval of a current billing interval may be calculated and combined with a usage level of all previous incremental intervals of the current billing interval to generate a cumulative usage record. An invoice for the billing interval may be generated based on the cumulative usage record.
-
公开(公告)号:US20230401180A1
公开(公告)日:2023-12-14
申请号:US18345987
申请日:2023-06-30
Applicant: Snowflake Inc.
Inventor: Istvan Cseri , Benoit Dageville , Ganeshan Ramachandran Iyer , Yucan Liu , Jiaqi Yan
IPC: G06F16/21
CPC classification number: G06F16/211
Abstract: Techniques for schema mismatch detection and evolution are described. When data is being uploaded into a source table, schema of the data to be uploaded can be compared with the schema for the source table. If a schema mismatch is detected, the schema of the source table can be modified, and the upload can be continued without data loss.
-
公开(公告)号:US11803373B1
公开(公告)日:2023-10-31
申请号:US18169819
申请日:2023-02-15
Applicant: Snowflake Inc.
Inventor: Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Benoit Dageville , Scott C. Gray , Unmesh Jagtap , Subramanian Muralidhar
CPC classification number: G06F8/71 , G06F8/658 , G06F9/4488
Abstract: Methodologies for upgrading and patching an in-database application package and its application instances. A data platform determines a number of objects of an application instance running on the data platform at a previous version level of an application package of the application instance. In response to determining the number of objects of the application package running on the data platform at the previous version level of the application package is one or more, the data platform continues determining the number of objects running on the data platform at a previous version level of the application package. In response to determining the number of objects of the application instance running on the data platform at the previous version level of the application package is none, the data platform upgrades the application instance to the new version of the application package.
-
公开(公告)号:US11797497B2
公开(公告)日:2023-10-24
申请号:US18068998
申请日:2022-12-20
Applicant: Snowflake Inc.
Inventor: Damien Carru , Benoit Dageville , Subramanian Muralidhar , Eric Robinson , Sahaj Saini , David Schultz
CPC classification number: G06F16/212 , G06F16/285 , G06F21/6245
Abstract: Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. A bundle is a schema object with associated hidden schemas. A bundle can be created by a provider user and can be shared with a plurality of consumer users. The bundle can be used to enable code sharing and distribution without losing control while maintaining security protocols.
-
公开(公告)号:US11748375B2
公开(公告)日:2023-09-05
申请号:US16860976
申请日:2020-04-28
Applicant: Snowflake Inc.
Inventor: Thierry Cruanes , Benoit Dageville , Marcin Zukowski
IPC: G06F16/27 , G06F16/14 , G06F16/182 , G06F16/21 , G06F16/22 , G06F16/23 , G06F16/2453 , G06F16/2455 , G06F9/48 , G06F9/50 , 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: 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.
-
公开(公告)号:US20230267131A1
公开(公告)日:2023-08-24
申请号:US18123108
申请日:2023-03-17
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Eric Robinson , Martin Hentschel
IPC: G06F16/27 , G06F16/245
CPC classification number: G06F16/273 , G06F16/245 , H04L67/1097
Abstract: Methods and systems of managing database failure based on transaction request time is disclosed. A method includes copying a first dataset stored in a primary deployment to a secondary deployment to generate a second dataset. The method includes determining a first arrival time of a first request to perform a first transaction. The method includes determining a second arrival time of a second request to perform a second transaction. The method includes e00000xecuting the first transaction on the first dataset at the primary deployment in response to determining the first arrival time of the first request to perform the first transaction. The method includes executing the second transaction on the second dataset at the secondary deployment in response to determining the second arrival time of the second request to perform the second transaction.
-
公开(公告)号:US11734280B2
公开(公告)日:2023-08-22
申请号:US17654887
申请日:2022-03-15
Applicant: Snowflake Inc.
Inventor: Thierry Cruanes , Benoit Dageville , 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 micro-partitions is accessed by a network-based data warehouse. A pruning index is generated based on the source table. The pruning index comprises a set of filters that indicate locations of distinct values in each column of the source table. A query directed at the source table is received at the network-based data warehouse. The query is processed using the pruning index. The processing of the query comprises pruning the set of micro-partitions of the source table to scan for data matching the query, the pruning of the plurality of micro-partitions comprising identifying, using the pruning index, a sub-set of micro-partitions to scan for the data matching the query.
-
公开(公告)号:US20230244693A1
公开(公告)日:2023-08-03
申请号:US18296444
申请日:2023-04-06
Applicant: Snowflake Inc.
Inventor: Thierry Cruanes , Benoit Dageville , Marcin Zukowski
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 , G06F16/28 , G06F16/25 , A61F5/56 , G06F9/48 , H04L67/1095 , H04L67/1097
CPC classification number: G06F16/27 , G06F9/5016 , G06F16/148 , G06F16/211 , G06F16/221 , G06F16/951 , G06F16/1827 , G06F16/2365 , G06F16/2456 , G06F16/2471 , G06F16/9535 , G06F16/24532 , G06F16/24545 , G06F16/24552 , H04L67/568 , G06F16/283 , G06F16/254 , A61F5/566 , G06F9/4881 , G06F9/5088 , H04L67/1095 , G06F9/5044 , H04L67/1097 , G06F9/5083
Abstract: Example resource management systems and methods are described. The method includes providing a plurality of processors and a plurality of cache memories in association with a virtual data warehouse management system, wherein each of the plurality of processors is associated with a stateless node. The method includes monitoring a performance of at least one processor of the plurality of processors to process database data. The method includes detecting a failure associated with the stateless node to process the database data responsive to monitoring the performance of the at least one processor of the plurality of processors to process the database data. The method includes replacing the stateless node with a different node without recreating a particular state.
-
公开(公告)号:US20230214391A1
公开(公告)日:2023-07-06
申请号:US18183483
申请日:2023-03-14
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
CPC classification number: G06F16/2379 , G06F16/2228 , G06F7/14 , G06F21/6218
Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US20230205783A1
公开(公告)日:2023-06-29
申请号:US18118595
申请日:2023-03-07
Applicant: SNOWFLAKE INC.
Inventor: Benoit Dageville , Thierry Cruanes , Marcin Zukowski , Allison Waingold Lee , Philipp Thomas Unterbrunner
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 , G06F16/28 , G06F16/25 , A61F5/56 , G06F9/48 , H04L67/1095 , H04L67/1097
CPC classification number: G06F16/27 , G06F9/5016 , G06F16/148 , G06F16/211 , G06F16/221 , G06F16/951 , G06F16/1827 , G06F16/2365 , G06F16/2456 , G06F16/2471 , G06F16/9535 , G06F16/24532 , G06F16/24545 , G06F16/24552 , H04L67/568 , G06F16/283 , G06F16/254 , A61F5/566 , G06F9/4881 , G06F9/5088 , H04L67/1095 , G06F9/5044 , H04L67/1097 , G06F9/5083
Abstract: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.
-
-
-
-
-
-
-
-
-