公开(公告)号：US11868502B2

公开(公告)日：2024-01-09

申请号：US18341935

申请日：2023-06-27

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.

公开(公告)号：US11868369B2

公开(公告)日：2024-01-09

申请号：US17667268

申请日：2022-02-08

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Marcin Zukowski

IPC: G06F15/167 ,  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 ,  G06F16/9538 ,  G06F9/48 ,  H04L67/1095 ,  H04L67/1097

CPC classification number: G06F16/273 ,  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/27 ,  G06F16/283 ,  G06F16/951 ,  G06F16/9535 ,  G06F16/9538 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/568

Abstract: Example resource management systems and methods are described. In one implementation, a resource manager is configured to manage data processing tasks associated with multiple data elements. An execution platform is coupled to the resource manager and includes multiple execution nodes configured to store data retrieved from multiple remote storage devices. Each execution node includes a cache and a processor, where the cache and processor are independent of the remote storage devices. A metadata manager is configured to access metadata associated with at least a portion of the multiple data elements.

公开(公告)号：US11853274B2

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

申请号：US17971482

申请日：2022-10-21

Applicant: Snowflake Inc.

Inventor： Ganeshan Ramachandran Iyer ,  Raghav Ramachandran ,  Subramanian Muralidhar

IPC: G06F16/00 ,  G06F16/215 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/2457

CPC classification number: G06F16/215 ,  G06F16/248 ,  G06F16/24552 ,  G06F16/24573

Abstract: Disclosed are techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein the data exchange includes a metadata storage where metadata including a list of files ingested is stored. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested into the data exchange, the set of bloom filters may be used to identify from within the set of candidate files, each candidate file that is duplicative of a file in the first set of files.

公开(公告)号：US20230412647A1

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

申请号：US18353445

申请日：2023-07-17

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Timothy S. Conkling ,  Thierry Cruanes ,  Benoit Dageville ,  Unmesh Jagtap ,  William A. Pugh ,  Shrikant Ravindra Shanbhag ,  Xu Xu

IPC: H04L9/40 ,  G06F16/955

CPC classification number: H04L63/20 ,  G06F16/955 ,  H04L63/102

Abstract: A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.

公开(公告)号：US20230409639A1

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

申请号：US18104271

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Khalid Zaman Bijon ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Daniel N. Meredith ,  Subramanian Muralidhar ,  David Schultz ,  Zixi Zhang

IPC: G06F16/903

CPC classification number: G06F16/90335

Abstract: A system for enforcing projection constraints on data values stored in specified variables of a shared dataset of a cloud data platform. A request is received from a first account of the cloud data platform that identifies a first operation to be performed on the shared dataset. A first set of data, including data accessed from a first variable, is accessed from the shared dataset to use in performing the first operation. A projection constraint policy attached to the first variable of the shared dataset is determined, and the projection constraint policy is further determined to be enforced based on the request. Based on the first set of data and the first operation, an output to the first request is generated.

公开(公告)号：US20230409430A1

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

申请号：US18104249

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Selcuk Aya ,  Leonid Baraznenok ,  Jaeha Lee ,  Adrian Peter Neumann ,  Ryan Michael Thomas Shelly ,  Zerui Wei ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F11/07 ,  G06F16/215

CPC classification number: G06F11/1435 ,  G06F16/215 ,  G06F11/079

Abstract: Embodiments of the present disclosure may provide a data protection system that performs identification of errors from queries on a database. The data protection system can further identify corrupted data from additional errors, are difficult to detect, and occur between layers of data in the database system. The data protection system can perform corrections of the error data by rebuilding database data or removing the corrupted data.

公开(公告)号：US20230401329A1

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

申请号：US17933761

申请日：2022-09-20

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Polita Paulus ,  Saurin Shah ,  Srinidhi Karthik Bisthavalli Srinivasa

IPC: G06F21/62 ,  G06F16/21

CPC classification number: G06F21/6218 ,  G06F16/211

Abstract: Provided herein are systems and methods for sharing unstructured data in stages. For example, a method includes generating a share object at an account of a data provider. The share object identifies an account of a data consumer and at least one unstructured data file shared with the account of the data consumer. The share object is configured with access privileges to the at least one unstructured data file. A notification of the share object is communicated to the account of the data consumer.

公开(公告)号：US20230401232A1

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

申请号：US17823752

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Istvan Cseri ,  Dinesh Chandrakant Kulkarni ,  Mihir Dhananjay Kulkarni ,  Lanhao Wu ,  Di Fei Zhang

IPC: G06F16/27 ,  G06F21/62

CPC classification number: G06F16/275 ,  G06F21/6218

Abstract: In one aspect, a computer-implemented method includes detecting a committed version of recurrently executed tasks of a first data pipeline on a primary deployment that is hosted on a first cloud service, and replicating the committed version of the recurrently executed tasks to a second data pipeline on a secondary deployment that is hosted on a second cloud service.

公开(公告)号：US20230401229A1

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

申请号：US18051657

申请日：2022-11-01

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Chong Han ,  Nithin Mahesh ,  Aravind Ramarathinam ,  Saurin Shah ,  Yanrui Zhang

IPC: G06F16/27 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F16/256

Abstract: The distributed database can implement unstructured data replication using an internal or external storage location. Metadata, such as a directory table that lists the unstructured files, can be replicated across different deployments, followed by replication of the staged data. Replicating the staged data can be implemented by replication of only the stage metadata or replication of the database files between the deployments.

公开(公告)号：US20230401201A1

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

申请号：US18162710

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/242 ,  G06F16/27 ,  G06F16/2455

CPC classification number: G06F16/242 ,  G06F16/27 ,  G06F16/2456

Abstract: A method includes generating a defined access clean room in a provider database account, as well as installing, in a consumer account, an application instance that implements the defined access clean room. The method also includes sharing, by the provider database account, source provider data with the defined access clean room, where the sharing makes the source provider data accessible to the consumer database account via the application instance. The method further includes sharing, by the provider database account, a query template with the consumer database account via the application instance. Additionally, the method includes receiving a query generated by the consumer database account based on the query template, validating that the query is consistent with the query template, responsively generating query results by executing the query, as well as storing the query results in the consumer database account.