公开(公告)号：US20210084104A1

公开(公告)日：2021-03-18

申请号：US16746764

申请日：2020-01-17

Applicant: Snowflake Inc.

Inventor： Matthew Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth ,  Benoit Dageville

IPC: H04L29/08 ,  G06F16/2455 ,  H04L12/24

Abstract: Providing access to metrics on a private data exchange is described. An example computer-implemented method can include providing a data exchange by a cloud computing service on behalf of an entity. The data exchange may comprise several data listings provided by one or more data providers. The data listings reference one or more data sets stored in a data storage platform associated with the cloud computing service. The method may also include granting access the data listings, gathering consumer information based queries provided to data associated with the data listings, generating a new share comprising the consumer information, and granting access of the new share to the data provider that provided the data listing.

公开(公告)号：US20210081439A1

公开(公告)日：2021-03-18

申请号：US16746673

申请日：2020-01-17

Applicant: Snowflake Inc.

Inventor： Matthew Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth ,  Pui Kei Johnston Chu ,  Benoit Dageville

IPC: G06F16/28 ,  G06F16/2458 ,  G06F16/2457 ,  G06F9/50

Abstract: Providing a private data exchange is described. An example computer-implemented method can include providing a data exchange by a cloud computing service on behalf of an entity. The data exchange may comprise several data listings provided by one or more data providers. The data listings reference one or more data sets stored in a data storage platform associated with the cloud computing service. The method may also include designating a data exchange administrator account of the data exchange. The data exchange administrator account may be associated with the entity and may be capable of: granting and denying requests from data consumers to access the data exchange; and granting and denying requests from data providers to publish data listings on the data exchange.

公开(公告)号：US20210073207A1

公开(公告)日：2021-03-11

申请号：US17086253

申请日：2020-10-30

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Martin Hentschel ,  William Waddington

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

Abstract: The subject technology caches, in connection with processing a first query, one or more table-metadata files in at least one of a current version set of one or more table-metadata files and a new version set of one or more table-metadata files, the new version set of one or more table-metadata files comprising table metadata for a new version of a database table. The subject technology receives a subsequent query directed to the database table. The subject technology downloads, in connection with processing the subsequent query, at least one uncached table-metadata file in a scan set of table-metadata files for the subsequent query. The subject technology processes the subsequent query using the at least one uncached table-metadata file.

公开(公告)号：US10942925B1

公开(公告)日：2021-03-09

申请号：US16932462

申请日：2020-07-17

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Ismail Oukid ,  Stefan Richter

IPC: G06F16/20 ,  G06F16/2455 ,  G06F16/9035 ,  G06F16/28 ,  G06F16/22 ,  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.

公开(公告)号：US20210064503A1

公开(公告)日：2021-03-04

申请号：US17007589

申请日：2020-08-31

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F11/30 ,  G06F16/2458 ,  G06F11/34 ,  G06F16/242

Abstract: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

公开(公告)号：US20210049188A1

公开(公告)日：2021-02-18

申请号：US17086328

申请日：2020-10-31

Applicant: Snowflake, Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Allison Waingold Lee

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 ,  G06F9/48 ,  H04L29/08

Abstract: A system and method for managing data storage and data access with querying data in a distributed system without buffering the results on intermediate operations in disk storage.

公开(公告)号：US20210034640A1

公开(公告)日：2021-02-04

申请号：US17063612

申请日：2020-10-05

Applicant: SNOWFLAKE INC.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Allison Waingold Lee

IPC: G06F16/27 ,  G06F9/50 ,  H04L29/08 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/182 ,  G06F9/48 ,  G06F16/951 ,  G06F16/2458 ,  G06F16/14 ,  G06F16/21 ,  G06F16/23 ,  G06F16/9535 ,  G06F16/2453

Abstract: A system and method for managing data storage and data access with querying data in a distributed system without buffering the results on intermediate operations in disk storage.

公开(公告)号：US20210019439A1

公开(公告)日：2021-01-21

申请号：US17060584

申请日：2020-10-01

Applicant: SNOWFLAKE INC.

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

IPC: G06F21/62 ,  G06F16/25

Abstract: A method for sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.

公开(公告)号：US20210019331A1

公开(公告)日：2021-01-21

申请号：US17064888

申请日：2020-10-07

Applicant: Snowflake Inc.

Inventor： Eric Robinson ,  Benoit Dageville ,  Shigeyuki Takeda ,  Kristopher Wagner

IPC: G06F16/27 ,  G06F16/23 ,  H04L29/12 ,  H04L29/08 ,  G06F16/21

Abstract: The subject technology generates a unique identification that references a first connection object of a first deployment and a second connection object of a second deployment of a database. The subject technology receives a notification that the first deployment is unavailable, the notification that the first deployment is unavailable comprises an indication of a downtime for the first deployment. The subject technology provides an external connection group unique identification to the second deployment for the second deployment to determine whether a client is to be connected to the second deployment. The subject technology receives a uniform resource locator from the second deployment when a client device is to be connected to the second deployment, the uniform resource locator being provided to the client device for connecting to the second deployment.

公开(公告)号：US20200380007A1

公开(公告)日：2020-12-03

申请号：US16428592

申请日：2019-05-31

Applicant: Snowflake Inc.

Inventor： Justin Langseth ,  Pui Kei Johnston Chu ,  Prasanna Krishnan ,  Matthew J. Glickman ,  Christian Kleinerman ,  Benoit Dageville

IPC: G06F16/25 ,  G06F16/2455 ,  G06F21/62

Abstract: A data warehouse storing databases for a plurality of users, including service providers hosting data for other users of the data warehouse may implement a data exchange. A provider of data creates a listing in the exchange including metadata. A consumer browses the metadata and select a listing to add to consumed shares of the consumer. Browsing may be filtered to implement a private exchange. Adding of data may be limited by access controls requiring verification of the consumer's identity. The added data may be filtered to include only data that relates to the consumer. Sharing may be bi-directional such that a request to add a listing for first data of a provider may also reference second data of the consumer such that the first data is added to the consumed shares of the consumer and the second data is added to the consumed shares of the provider.