公开(公告)号：US20230418818A1

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

申请号：US18463904

申请日：2023-09-08

Applicant: Snowflake Inc.

Inventor： Prasanna Rajaperumal ,  Thierry Cruanes ,  Allison Waingold Lee ,  Igor Demura ,  Jiaqi Yan ,  Benoit Dageville

IPC: G06F16/2453

CPC classification number: G06F16/24539

Abstract: Systems, methods, and devices for sharing materialized views in multiple tenant database systems. A method includes defining a materialized view over a source table that is associated with a first account of a multiple tenant database. The method includes defining cross-account access rights to the materialized view to a second account such that that second account can read the materialized view without copying the materialized view. The method includes modifying the source table for the materialized view. The method includes identifying whether the materialized view is stale with respect to the source table by merging the materialized view and the source table.

公开(公告)号：US20230401235A1

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

申请号：US18456675

申请日：2023-08-28

Applicant: Snowflake Inc.

Inventor： Dhiraj Gupta ,  Subramanian Muralidhar

IPC: G06F16/27 ,  G06F16/18 ,  G06F16/2453 ,  G06F16/25

CPC classification number: G06F16/278 ,  G06F16/1815 ,  G06F16/24532 ,  G06F16/258

Abstract: Described herein are techniques for improving transfer of metadata from a metadata database to a database stored in a data system, such as a data warehouse. The metadata may be written into the metadata database with a version stamp, which is monotonic increasing register value, and a partition identifier, which can be generated using attribute values of the metadata. A plurality of readers can scan the metadata database based on version stamp and partition identifier values to export the metadata to a cloud storage location. From the cloud storage location, the exported data can be auto ingested into the database, which includes a journal and snapshot table.

公开(公告)号：US20230401199A1

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

申请号：US18353317

申请日：2023-07-17

Applicant: Snowflake Inc.

Inventor： Tyler Arthur Akidau ,  Tyler Jones ,  Daniel Mills ,  Leon Papke ,  Prasanna Rajaperumal ,  Daniel E. Sotolongo

IPC: G06F16/23 ,  G06F11/34

CPC classification number: G06F16/2393 ,  G06F11/3419

Abstract: A method includes retrieving a plurality of materialized tables (MTs). Each of the plurality of MTs includes a lag duration and refers to a corresponding base table of a plurality of base tables. The lag duration indicates a maximum time period that a result of a prior refresh of a query on the corresponding base table can lag behind a current time instance. A plurality of time instances for the MT is determined based on the lag duration and a number of prior refreshes of the corresponding base table. A plurality of aligned time instances for the plurality of MTs is determined based on the plurality of time instances for each of the plurality of MTs. Refresh operations are scheduled for the plurality of MTs at one or more of the plurality of aligned time instances that are within the maximum time period.

公开(公告)号：US11836138B1

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

申请号：US18162688

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Matthew J. Glickman ,  Orestis Kostakis ,  Justin Langseth

IPC: G06F16/245 ,  G06F16/24 ,  G06F16/2455 ,  G06F16/242

CPC classification number: G06F16/24568 ,  G06F16/244 ,  G06F16/2456 ,  G06F16/24564

Abstract: A system for generating similarity data for different datasets in a cloud data platform. A first dataset of a plurality of datasets on the cloud data platform is identified, where the first dataset is associated with a first user of the cloud data platform. A semantic type for each feature the first dataset is identified, and each semantic type for the first dataset is compared with existing data of the first user. Semantic types for each feature of each dataset are identified, and each semantic type for the first dataset is compared to each semantic type of each dataset. Overlap requests are generated to output overlap datasets between the first dataset and each of the plurality of datasets. A results dataset is generated by applying the overlap requests to a joined dataset comprising data from the first dataset and data from each of the plurality of datasets.

公开(公告)号：US20230385305A1

公开(公告)日：2023-11-30

申请号：US18051148

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Krishna B. Nibhanupudi ,  Zechao Shang

IPC: G06F16/28 ,  G06F16/23 ,  G06F16/182

CPC classification number: G06F16/283 ,  G06F16/23 ,  G06F16/182

Abstract: The subject technology sends a first statement to an execution node for executing the first statement on first storage using micro-partitions. The subject technology sends a second statement to the execution node for executing the second statement on linearizable storage. The subject technology sends a request to prepare a commit of a cross domain transaction associated with the first statement and the second statement. The subject technology generates a new version of a set of tables that were modified by the cross domain transaction and updating first metadata in a metadata database to indicate the new version. The subject technology finalizes the commit of the cross domain transaction and updates second metadata that the cross domain transaction has been committed.

公开(公告)号：US11824899B2

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

申请号：US18048248

申请日：2022-10-20

Applicant: Snowflake Inc.

Inventor： James Calvin Armstrong ,  Jonathan Claybaugh

IPC: H04L9/40 ,  H04L43/026 ,  H04L41/22 ,  H04L47/10 ,  H04L43/00 ,  H04L43/062 ,  H04L41/0604 ,  H04L43/0811 ,  G06F21/57 ,  G06F21/56 ,  G06F21/62

CPC classification number: H04L63/20 ,  G06F21/566 ,  G06F21/57 ,  H04L41/0604 ,  H04L41/22 ,  H04L43/00 ,  H04L43/026 ,  H04L43/062 ,  H04L43/0811 ,  H04L47/10 ,  H04L63/0263 ,  H04L63/104 ,  H04L63/1408 ,  H04L63/1416 ,  G06F21/6218 ,  H04L63/102

Abstract: The disclosure relates generally to methods, systems, and apparatuses for managing network connections. An example method includes receiving one or more messages from a plurality of computing devices connected through a network, the one or more messages indicating actual connections among the plurality of computing devices. The example method further includes comparing, by one or more processors, the actual connections to a list of expected connections indicated by a connections master file that comprises connection information for the plurality of computing devices. The method further includes, responsive to detecting one or more differences between the list of expected connections and the actual connections, providing a notification indicating the one or more differences to a log file or a notification area of a user interface.

公开(公告)号：US11822689B2

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

申请号：US18109191

申请日：2023-02-13

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Subramanian Muralidhar ,  Bowen Zhang

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

CPC classification number: G06F21/6218 ,  G06F16/21 ,  G06F16/256 ,  G06F2221/2141

Abstract: Embodiments of the present disclosure relate to sharing database roles using hidden roles. A database role may be generated within a database container having a plurality of data objects, wherein the database role exists exclusively within the database container. A set of grants to a particular subset of the plurality of data objects of the database container may be assigned to the database role and the database role may be granted to the share object. The share object is mounted within a consumer account to generate an imported database container within the consumer account, the imported database container including an imported copy of the database role. The imported copy of the database role may be granted to each of one or more account level roles of the consumer account to share the particular subset of the plurality of data objects without creating proxy objects in the consumer account that represent the particular subset of the plurality of data objects.

公开(公告)号：US11816582B2

公开(公告)日：2023-11-14

申请号：US17507691

申请日：2021-10-21

Applicant: SNOWFLAKE INC.

Inventor： David Jensen

IPC: G06N5/01 ,  G06F16/2455

CPC classification number: G06N5/01 ,  G06F16/24564

Abstract: A device searches for an anonymization of a data set using a heuristic search. The device receives a generalization lattice and one or more scoring functions. The device further can include selecting a start node in the generalization lattice. For each of the one or more scoring functions, the device can further include computing a path the generalization lattice from the start node that traverses the generalization lattice. In addition, the device can include determining an optimal path node from each of the one or more paths. Furthermore, the method can include selecting an optimal node from the one or more optimal path nodes.

公开(公告)号：US11809586B2

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

申请号：US17980427

申请日：2022-11-03

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Subramanian Muralidhar

IPC: G06F7/00 ,  G06F16/00 ,  G06F21/62 ,  G06F16/21 ,  G06F16/2455

CPC classification number: G06F21/6218 ,  G06F16/213 ,  G06F16/24552

Abstract: A consumer account may invoke an operation referencing a set of shared objects stored within a database of a provider account using an imported database that makes the set of shared objects available within the consumer account. A call context of the operation may be updated to cache the imported database, which references a share created from the provider account database, the share having grants to the set of shared objects. One or more database level objects may be discovered in a context of the share and each role granted to the share may be obtained based on the one or more database level objects. Whether any role granted to the share has access to any of the set of shared objects may be determined and the operation may be executed for each of the set of shared objects to which any role granted to the share has access.

公开(公告)号：US20230350893A1

公开(公告)日：2023-11-02

申请号：US18172688

申请日：2023-02-22

Applicant: Snowflake Inc.

Inventor： Bicheng Gao ,  Nicola Dan Onose ,  Jiaqi Yan

IPC: G06F16/2453 ,  G06F16/23

CPC classification number: G06F16/24544 ,  G06F16/2365

Abstract: A source table can be provided by a provider account in a data system. A secure view of the source table is provided to one or more consumer accounts, the secure view limiting access to a subset of data in the source table. A plan to execute a command using the secure view may be generated, the plan including a secure view boundary on a subset of operations defining the secure view. The plan may be modified to move a first operation that was outside the secure view boundary to within the secure view boundary to generate a second plan to optimize performance in view of limitations or restrictions placed by the secure view.