公开(公告)号：US11748514B2

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

申请号：US17160924

申请日：2021-01-28

Applicant: Snowflake Inc.

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

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

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

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.

公开(公告)号：US11748327B2

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

申请号：US17648622

申请日：2022-01-21

Applicant: Snowflake Inc.

Inventor： Tyler Arthur Akidau ,  Istvan Cseri ,  Tyler Jones ,  Daniel E. Sotolongo

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

CPC classification number: G06F16/2282 ,  G06F16/2358 ,  G06F16/24568

Abstract: A system or persistent table may be generated storing changelog information of a primary base table. The system table may then be used to create streams of relevant information. In some examples, the streams may read from the system table for information past a retention period of the primary table while reading from the primary table information in the retention period.

公开(公告)号：US11736483B2

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

申请号：US18050909

申请日：2022-10-28

Applicant: Snowflake Inc.

Inventor： Derek Denny-Brown ,  Tyler Jones ,  Isaac Kunen

IPC: H04L9/40 ,  G06F21/31

CPC classification number: H04L63/0884 ,  G06F21/31 ,  H04L63/083 ,  H04L63/10

Abstract: A credentials store definition identifying a remote credential store is received. The credential store definition includes access information to enable access to the remote credentials store. A credentials object is created in an internal database based on a credentials object definition. The credentials object identifies a security credential to retrieve from the remote credentials store to access an external resource. At runtime, a request to access the external resource is received, and based on receiving the request, the security credentials identified by the credentials object are retrieved from the remote credential store using the access information. The retrieved security credential is provided to a processing component to access the external resource.

公开(公告)号：US11734451B1

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

申请号：US17931424

申请日：2022-09-12

Applicant: Snowflake Inc.

Inventor： Abhiram Arikapudi ,  Brian Jack Lee ,  Saurin Shah ,  Cameron Tekiyeh ,  Sujay C. Yantrapragada

IPC: G06F21/00 ,  G06F21/62 ,  G06F16/242

CPC classification number: G06F21/6254 ,  G06F16/2445

Abstract: An exchange template framework for a data platform. A data provider of the data platform instructs the data platform to generate an exchange template based on compliance rules. In response to determining by the data platform to initiate a compliance report, the data platform maps evidence items for the compliance report from one or more source tables using a data field mapper of the exchange template. The data platform generates compliance program specific views based on the evidence items mapped from the source tables and generates an anonymized view based on the compliance program specific views using an anonymization layer of the exchange template. The data platform provides the anonymized view to an assessor using one or more validation scripts of the exchange template.

公开(公告)号：US11734301B1

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

申请号：US17656116

申请日：2022-03-23

Applicant: Snowflake Inc.

Inventor： Istvan Cseri ,  Tyler Jones ,  Daniel E. Sotolongo ,  Boyuan Zhang

IPC: G06F16/30 ,  G06F16/27

CPC classification number: G06F16/27

Abstract: Techniques described herein can enable stream replication. A first deployment can store a table including one or more streams. The techniques described herein can be used to replicate the table at a second deployment while replicating the one or more streams associated with the table. Select prior table versions and partitions in the table are copied to the second deployment to enable stream replication.

公开(公告)号：US11727139B2

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

申请号：US17936681

申请日：2022-09-29

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Khalid Zaman Bijon ,  Zheng Mi ,  Subramanian Muralidhar ,  David Schultz ,  Jian Xu

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

CPC classification number: G06F21/6227 ,  G06F16/2282 ,  G06F21/604 ,  G06F21/62 ,  G06F21/6218 ,  G06F2221/2141

Abstract: Row-level security (RLS) may provide fine-grained access control based on flexible, user-defined access policies to databases, tables, objects, and other data structures. A RLS policy may be an entity or object that defines rules for row access. A RLS policy may be decoupled or independent from any specific table. This allows more robust and flexible control. A RLS policy may then be attached to one or more tables. The RLS policy may include a Boolean-valued expression.

公开(公告)号：US11726996B2

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

申请号：US17654147

申请日：2022-03-09

Applicant: Snowflake Inc.

Inventor： Orestis Kostakis

IPC: G06F16/24 ,  G06F16/245 ,  G06F11/36

CPC classification number: G06F16/245 ,  G06F11/362

Abstract: Disclosed herein are embodiments of systems and methods for analyzing query comments for identifying potential software bugs. In an example, a data platform obtains query comments associated with a query. Based on determining that the query comments include a reference to a software bug of the data platform, the data platform generates a software-bug alert based on the query comments, and transmits the software-bug alert to an endpoint.

公开(公告)号：US20230252179A1

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

申请号：US17665027

申请日：2022-02-04

Applicant: Snowflake Inc.

Inventor： Emily B. Dillon ,  Travis Kaufman ,  Adil Lalani ,  Paul O. Lanzoni ,  Shakhina Pulatova

IPC: G06F21/62 ,  G06F16/2458 ,  G06F16/28

CPC classification number: G06F21/6227 ,  G06F16/2465 ,  G06F16/283 ,  G06F2221/2113 ,  G06F2221/2141

Abstract: Embodiments of the present disclosure provide techniques for associating use case data with data listings in a structured manner, thereby allowing for data listings to be organized and/filtered based on use case information. A processing device may provide a listing creation interface that is used to assign a set of use cases to a first data listing and publish the data listing on a data exchange. The data listing is one of a plurality of data listings published on the data exchange and the processing device may provide a data listing interface for displaying the plurality of data listings and an interactable menu including a selectable indication of each of the plurality of use cases. In response to receiving a selection of one or more of the plurality of use cases via the interactable menu, the processing device may display in the data listing interface, each of the plurality of data listings that have been assigned any of the selected one or more use cases.

公开(公告)号：US20230244642A1

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

申请号：US18134186

申请日：2023-04-13

Applicant: SNOWFLAKE INC.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  German Alberto Gil Echeverri ,  Prasanna Krishnan ,  Vishnu Dutt Paladugu ,  Bowen Zhang

IPC: G06F16/182 ,  G06F16/11 ,  G06F9/54 ,  G06F16/17

CPC classification number: G06F16/1844 ,  G06F16/128 ,  G06F9/546 ,  G06F16/1827 ,  G06F16/1734

Abstract: Provided herein are systems and methods for replicating share objects to remote deployments. An example method includes generating, at a second deployment in a data exchange, a replica of a share object included in a first deployment of the data exchange. The share object grants privileges to a first account to access a first database of the first deployment, wherein the first database comprises a database object. The method also includes retrieving, at the first deployment, share grant metadata from the share object of the first deployment, wherein the share grant metadata includes a reference to the database object and allows the first account to use the database object. The method also includes transmitting a message comprising the share grant metadata to the replica in the second deployment. The share grant metadata in the replica allows a second account to use the database object replicated in the second deployment.

公开(公告)号：US20230222142A1

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

申请号：US18124415

申请日：2023-03-21

Applicant: SNOWFLAKE INC.

Inventor： Craig E. HAWCO ,  Joseph David JENSEN

IPC: G06F16/28 ,  G06N5/01 ,  G06F16/22

CPC classification number: G06F16/285 ,  G06N5/01 ,  G06F16/221

Abstract: Systems and method are disclosed that retrieve data from a data set organized in a plurality of columns. For each column in the plurality of columns, the systems and method generate one or more candidate semantic categories for the column, where each of the one or more candidate semantic categories has a corresponding probability. The systems and method create a feature vector for the column from the one or more candidate semantic categories and the corresponding probabilities. The systems and method determine a semantic category type of the column based on the feature vector. The systems and method anonymize the data in the column based on the semantic category type, which includes replacing more specific data in the column with less specific data based on a data hierarchy that relates the more specific data to the less specific data.