公开(公告)号：US20240303373A1

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

申请号：US18345971

申请日：2023-06-30

Applicant: Snowflake Inc.

Inventor： Khalid Zaman Bijon ,  Bowei Chen ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Valentin K. Kuznetsov ,  Jun Li ,  Subramanian Muralidhar ,  Carl Yates Perry ,  David Schultz ,  Zixi Zhang

IPC: G06F21/62 ,  G06F16/242

CPC classification number: G06F21/6245 ,  G06F16/244 ,  G06F2221/2113

Abstract: The cloud data platform receives a first query directed towards a shared dataset, the first query identifying a first operation. The platform accesses a first set of data from the shared dataset to perform the first operation, the first set of data including data accessed from a first table of the shared dataset. The cloud data platform determines that an aggregation constraint policy is attached to the first table, the aggregation constraint policy restricts output of data values stored in the first table and enforces the aggregation constraint policy on the first query based on a context of the first query. The cloud data platform generates an output to the first query based on the first set of data and the first operation, based on enforcing the aggregation constraint policy on the first query.

公开(公告)号：US20240289351A1

公开(公告)日：2024-08-29

申请号：US18637833

申请日：2024-04-17

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

IPC: G06F16/27 ,  G06F16/182 ,  G06F16/245

CPC classification number: G06F16/273 ,  G06F16/1844 ,  G06F16/245

Abstract: Techniques for remote deployment replication using data objects preparation objects include detecting at an account of a data provider at the remote deployment, a replication request for availability of an instance of a primary deployment database to account of a data consumer at the remote deployment. Responsive to the replication request, the account of the data provider at the remote deployment is provisioned with a plurality of data objects associated with the primary deployment database. A refresh operation is invoked using at least one data object of the plurality of data objects at the remote deployment, to generate the instance of the primary deployment database in the account of the data consumer.

公开(公告)号：US12032995B1

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

申请号：US18361549

申请日：2023-07-28

Applicant: Snowflake Inc.

Inventor： Gabriel Kliot ,  Ruji Xie ,  Subramanian Muralidhar ,  William Waddington

IPC: G06F9/48

CPC classification number: G06F9/4881

Abstract: A method includes decoding, by at least one hardware processor, an enqueue request received from a data process of a database system. The enqueue request includes a task. The task is enqueued in an in-memory task queue. An enqueue acknowledgment is encoded for transmission to the data process responsive to the enqueue request. The task is persisted in a storage location associated with the in-memory task queue. Initiate a lease of the task to a worker node in response to a lease request received from the worker node. A dequeue request is received from the worker node where the dequeue request indicates completion of the task by the worker node. The task is dequeued from the in-memory task queue based on the dequeue request.

公开(公告)号：US12032947B1

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

申请号：US18354003

申请日：2023-07-18

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Benoit Dageville ,  Unmesh Jagtap ,  Subramanian Muralidhar ,  Jan Michael Timmerman

IPC: G06F8/65 ,  G06F16/21

CPC classification number: G06F8/65 ,  G06F16/219

Abstract: A versioned schema of a data platform. A process of maintaining a call stack of executing objects of an application package having a versioned schema includes calling, by a first procedure executed by one or more processors, a second procedure of a versioned application instance, and determining, by the first procedure, a version of the second procedure based on a call context. In response to determining that the version of the second procedure is not in the call context, the first procedure determines a current version of the versioned application package adds the current version to the call context as the version of the second procedure.

公开(公告)号：US12001552B1

公开(公告)日：2024-06-04

申请号：US18168852

申请日：2023-02-14

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Iulia Ion ,  Unmesh Jagtap ,  Subramanian Muralidhar ,  James Pan ,  Nihar Pasala ,  Hrushikesh Shrinivas Paralikar ,  Jake Tsuyemura ,  Ryan Charles Quistorff ,  Rishabh Gupta

IPC: G06F21/56 ,  G06F8/60

CPC classification number: G06F21/565 ,  G06F8/60 ,  G06F2221/033

Abstract: An anti-abuse system is provided for a data-platform. An anti-abuse scanner of the data-platform detects a creation of an application package by a provider of content to the data platform where the application package includes a set of files for deployment on the data platform. The anti-abuse scanner performs a review of the set of files to detect malicious content where the review is based on a set of analysis rules and generates a deployment decision for the application package based on a result of the review.

公开(公告)号：US20240119056A1

公开(公告)日：2024-04-11

申请号：US18545672

申请日：2023-12-19

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Khalid Zaman Bijon ,  Yujie Li ,  Zheng Mi ,  Subramanian Muralidhar ,  David Schultz

IPC: G06F16/2457 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/27 ,  G06F16/28

CPC classification number: G06F16/24573 ,  G06F16/211 ,  G06F16/212 ,  G06F16/2291 ,  G06F16/2365 ,  G06F16/27 ,  G06F16/288 ,  G06F16/289

Abstract: A method of implementing object tagging framework starts with the processor receiving a tag creation command including a tag name. In response to the tag creation command, the processor creates a current tag. The processor then receives an association command, the tag name and a source object identifier. The processor determines a source object associated with the source object identifier. The source object includes a tag value. The processor associates the current tag with the source object. The processor receives a replication command including the source object and a target object. The processor causes replication of the source object to the target object that comprises replicating the current tag with the tag name and the tag value in the source object to the target object. Other embodiments are also described herein.

公开(公告)号：US20240111784A1

公开(公告)日：2024-04-04

申请号：US18447897

申请日：2023-08-10

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F16/27 ,  G06Q30/0201

CPC classification number: G06F16/27 ,  G06Q30/0206 ,  G06Q30/0601

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. The data listing distribution component distributes the data dictionaries to various remote deployments in a data exchange by using a global messaging framework and replication method. For example, the data listing distribution component replicates a data dictionary generated for the listing and its shared data from a source deployment to one or more destination deployments associated with various geographic regions. The data listing distribution component distributes the listing to the various remote deployments to allow for the listing, including its shared data and data dictionary, to be accessed by users within the geographic region associated with the remote deployment.

公开(公告)号：US11928098B2

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

申请号：US17809203

申请日：2022-06-27

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

IPC: G06F16/23 ,  G06F16/18 ,  G06F16/245 ,  G06F16/27 ,  G06F9/46

CPC classification number: G06F16/2358 ,  G06F16/1865 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/245 ,  G06F16/278 ,  G06F9/466

Abstract: A system includes one or more processors and data storage containing instructions executable by the one or more processors to perform operations. The operations include detecting a first executed transaction causing a first modification to table data stored in a table. The table data is associated with a corresponding metadata file with metadata information of the table. A new metadata file is generated responsive to the first executed transaction. The new metadata file includes the metadata information and additional metadata associated with the first modification. A second executed transaction causing a second modification to the table data is detected. The table data is updated with a change tracking column. The change tracking column includes lineage of executed transactions on the table data. The lineage indicates at least the first transaction and the second transaction.

公开(公告)号：US20240062197A1

公开(公告)日：2024-02-22

申请号：US18198220

申请日：2023-05-16

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Tyson J. Hamilton ,  Unmesh Jagtap ,  Xiaodi Ke ,  Haroldo Level ,  Subramanian Muralidhar ,  James Pan ,  Steven Parkes ,  Xie Xu

IPC: G06Q20/38 ,  H04L9/40

CPC classification number: G06Q20/3829 ,  H04L63/0428

Abstract: Disclosed is an execution information sharing system that writes execution information to a provider target (and other targets) in a secure manner. Execution information generated by an application may be written to a consumer stage, wherein the application is shared by a provider account of a data exchange with a consumer account that executes the application. A consumer exchange service (ES) of the data exchange may send a request to a copy service of the data exchange to copy the execution information from the consumer stage to the provider stage, wherein the consumer ES is a part of the data exchange and is protected from actions of the consumer account. A copy operation may be executed to copy the execution information from the consumer stage to the provider stage using the copy service of the data exchange. The execution information is ingested from the provider stage to a provider table.

公开(公告)号：US20240061860A1

公开(公告)日：2024-02-22

申请号：US18498657

申请日：2023-10-31

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Khondokar Sami Iqram ,  Subramanian Muralidhar ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/27 ,  H04L9/40

CPC classification number: G06F16/27 ,  H04L63/0272

Abstract: A database system can configure network devices, such as a primary database in a multi-tenant deployment and a secondary database in a private deployment, to send and receive sequence messages, such as input data indicative of a selection of a link. The database system can create a secure share area in the private deployment in response to receiving the input data indicative of the selection of the link. The database system can replicate the data from the multi-tenant deployment to the secure share area in the private deployment and share the replicated data from the secure share area to the secondary database hosted in the private deployment.