公开(公告)号：US11669427B2

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

申请号：US17657393

申请日：2022-03-31

Applicant: Snowflake Inc.

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

IPC: G06F11/14 ,  G06F11/30 ,  G06F11/32 ,  G06F16/248 ,  G06F16/2458 ,  G06F16/242 ,  G06F11/34

CPC classification number: G06F11/3072 ,  G06F11/1402 ,  G06F11/327 ,  G06F11/3409 ,  G06F16/248 ,  G06F16/2425 ,  G06F16/2465 ,  G06F16/2474

Abstract: Disclosed herein are embodiments of systems and methods for query-attempt processing in a database environment. In an embodiment, a database platform receives a query, and operates a first query manager of the database platform to manage a first attempt to execute the query. Based on determining that the attempt to execute the query was unsuccessful, the database platform identifies a second query manager of the database platform as implementing a same version of the database platform as the first query manager, and operates the second query manager to manage a first retry attempt to execute the query.

公开(公告)号：US20230169407A1

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

申请号：US18162697

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Monica J. Holboke ,  Justin Langseth ,  Stuart Ozer ,  William L. Stratton, JR.

IPC: G06N20/00 ,  G06F21/62 ,  G06F16/25 ,  G06F16/28 ,  G06F18/214

CPC classification number: G06N20/00 ,  G06F21/6227 ,  G06F16/256 ,  G06F16/283 ,  G06F18/214

Abstract: A system for providing access to a database management system (DBMS) to a first user of a cloud data platform, the DBMS being generated by a second user. A machine learning model for training on a training dataset is included in the DBMS. The training dataset includes a first training dataset that is encrypted in the DBMS and a second training dataset that includes non-overlapping features with the first training dataset. A request, from the second user, to train the machine learning model on the first and second training datasets is identified. A trained machine learning model is generated by training the machine learning model on a joined dataset according to the request. One or more outputs from the trained machine learning model are generated by applying the trained machine learning model on new data.

公开(公告)号：US20230169212A1

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

申请号：US18104281

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Joshua James Chacona ,  Christian Kleinerman ,  Justin Langseth ,  William L. Stratton, JR.

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

CPC classification number: G06F21/6254 ,  G06F21/6263 ,  G06F16/2455 ,  G06F16/2282

Abstract: Embodiments of the present disclosure may provide a data clean room allowing secure data analysis across multiple accounts, without the use of third parties. Each account may be associated with a different company or party. The data clean room may provide security functions to safeguard sensitive information. For example, the data clean room may restrict access to data in other accounts. The data clean room may also restrict which data may be used in the analysis and may restrict the output. The overlap data may be anonymized to prevent sensitive information from being revealed.

公开(公告)号：US20230169090A1

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

申请号：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/27 ,  G06F11/14 ,  G06F11/20 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F11/1464 ,  G06F11/1461 ,  G06F11/2023 ,  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.

公开(公告)号：US20230169087A1

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

申请号：US18160802

申请日：2023-01-27

Applicant: SNOWFLAKE INC.

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

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

CPC classification number: G06F16/254 ,  G06F21/6218 ,  G06F16/2456

Abstract: A method includes creating, by a first provider, a first listing referencing first shared data and comprising first access controls, wherein access to the first shared data by a second provider is filtered based on the first access controls, creating, by the second provider, a second listing referencing second shared data and the first shared data filtered based on the first access controls, and adding the second listing to a catalog in a data exchange, the catalog comprising metadata describing the second shared data.

公开(公告)号：US20230168988A1

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

申请号：US18160908

申请日：2023-01-27

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

CPC classification number: G06F11/3082 ,  G06F16/2465 ,  G06F11/3438 ,  G06F11/3409 ,  G06F16/2425 ,  G06F16/2474

Abstract: Automated query retry includes selecting a first node of a plurality of nodes of an execution platform in response to a query. The first node is configured with a first version of a database platform. A first execution of the query is performed using the first version of the database platform at the first node. The method further includes detecting the first execution results in a failed execution. A second execution of the query is scheduled. The second execution uses at least one of the first version of the database platform or a second version of the database platform configured at a second node of the plurality of nodes. The second version is released after the first version. A cause of the failed execution of the query at the first node is determined based at least in part on a result of the second execution of the query.

公开(公告)号：US20230168987A1

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

申请号：US18160720

申请日：2023-01-27

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

CPC classification number: G06F11/3082 ,  G06F16/2465 ,  G06F11/3438 ,  G06F11/3409 ,  G06F16/2425 ,  G06F16/2474

Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data. The query is received by a first management node from a client account of a database system. The method further includes configuring an execution of the query by a first computing node associated with the first management node. The method includes detecting the execution of the query results in a failed execution. The query is transferred from the first management node to a second management node based on the failed execution. The second management node is configured to process tasks that are internal to the database system. A retry execution of the query by a second computing node is configured. The second computing node is associated with the second management node. A cause of the failed execution is determined based on a result of the retry execution.

公开(公告)号：US20230161765A1

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

申请号：US18099866

申请日：2023-01-20

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Florian Andreas Funke ,  Guangyan Hu ,  Jiaqi Yan

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/22

CPC classification number: G06F16/24537 ,  G06F16/24556 ,  G06F16/2255

Abstract: Joining data using a disjunctive operator using a lookup table is described. An example computer-implemented method can include receiving a query with a set of conjunctive predicates and a set of disjunctive predicates. The method may also include generating a lookup table for each predicate in the sets of conjunctive predicates and disjunctive predicates. The method, for each row in a probe-side table, may also further include looking up a value associated with that row in each of the lookup tables and adding the row to a results set when there is a match. Additionally, the method may also include returning the results set.

公开(公告)号：US20230161735A1

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

申请号：US18160021

申请日：2023-01-26

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Thierry Cruanes ,  Marcin Zukowski ,  Allison Waingold Lee ,  Philipp Thomas Unterbrunner

IPC: G06F16/172 ,  G06F16/13 ,  G06F16/182 ,  G06F16/22 ,  G06F16/2455

CPC classification number: G06F16/172 ,  G06F16/137 ,  G06F16/1827 ,  G06F16/2237 ,  G06F16/2255 ,  G06F16/2456

Abstract: A query directed to database data stored across a set of files is received. The query includes predicates applied against metadata of the set of files. One or more files are removed from the set of files whose metadata does not satisfy a predicate of the plurality of predicates. Rows of the one or more remaining files of the set of files are filtered based on the one or more predicates.

公开(公告)号：US11645298B1

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

申请号：US17934857

申请日：2022-09-23

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 managed event tables include generating at a first process of an execution node, log data associated with execution of user-defined function (UDF) code. The log data is provided from the first process to a second process of the execution node. The first process is configured as a sub-process of the second process. The log data is formatted using the second process of the execution node, to generate formatted log data. The formatting is based on a configuration of a managed event table that is external to the execution node. The formatted log data is communicated from the second process of the execution node into a managed event table maintained at a computing node that is external to the execution node.