公开(公告)号：US20240403323A1

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

申请号：US18806986

申请日：2024-08-16

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Shreyas Narendra Desai ,  German Alberto Gil Echeverri ,  Prasanna Krishnan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Eric Robinson ,  Sahaj Saini

IPC: G06F16/27 ,  G06F16/22 ,  G06F16/23 ,  G06Q30/018 ,  G06Q30/0204

Abstract: A system for sub-table replication within a materialized view of a source data table. A materialized view of a source data table is generated based on a query, the source data table having a plurality of data table rows associated with a plurality of client identifiers and including an entitlements column and data content, the entitlements column including a plurality of provider account identifiers and a plurality of consumer account identifiers. An update to an entitlements table of the source data table is detected where the entitlements table includes a plurality of entitlements table rows and where the entitlements table rows are associated with the client identifiers, the consumer account identifiers, and the provider account identifiers. An update to the source data table based on the first update to the entitlements table is detected, and an incremental replication of the materialized view of the source data table is performed.

公开(公告)号：US20240386010A1

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

申请号：US18426772

申请日：2024-01-30

Applicant: Snowflake Inc.

Inventor： Abdullah Al Mahmood ,  Tyler Jones ,  Xin Huang ,  Ganeshan Ramachandran Iyer ,  Jiaxing Liang ,  Daniel Mills ,  Subramanian Muralidhar ,  Daniel E. Sotolongo

IPC: G06F16/23 ,  G06F11/14 ,  G06F16/22

Abstract: Techniques for creating and using error tables to track errors associated with a base table are described. A command to perform an operation on a base table stored in a network-based data system can be received and executed, causing at least one error. At least one error record corresponding to the at least one error can be inputted into an error table, which is nested with the base table. Contextual information can be added to the at least one error record.

公开(公告)号：US20240281557A1

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

申请号：US18652655

申请日：2024-05-01

Applicant: SNOWFLAKE INC.

Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Thierry Cruanes ,  Istvan Cseri ,  Benoit Dageville ,  Unmesh Jagtap ,  Subramanian Muralidhar

IPC: G06F21/62 ,  G06F9/445 ,  G06Q30/06

CPC classification number: G06F21/6227 ,  G06F9/44505 ,  G06Q30/06 ,  G06F2221/2141

Abstract: Embodiments of the present disclosure related to sharing applications within a data sharing platform. An example method includes replicating a database from a provider account of a data sharing platform to a consumer account of the data sharing platform. The method further includes executing an installation script within the consumer account to install an application in the consumer account of the data sharing platform responsive to the replicating. The method further includes creating, by a processing device, a set of database roles to manage execution of the application in the consumer account, wherein one or more of the set of database roles determine access privileges granted to the application for accessing the database inside the consumer account. The application is to perform a data processing service relative to a data asset in the database.

公开(公告)号：US20240281245A1

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

申请号：US18470585

申请日：2023-09-20

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Scott C. Gray ,  Unmesh Jagtap ,  Subramanian Muralidhar

IPC: G06F8/71 ,  G06F8/658 ,  G06F9/448

CPC classification number: G06F8/71 ,  G06F8/658 ,  G06F9/4488

Abstract: Methodologies for upgrading and patching an in-database application package and its application instances. A data platform determines a number of objects of an application instance running on the data platform at a previous version level of an application package of the application instance. In response to determining the number of objects of the application package running on the data platform at the previous version level of the application package is one or more, the data platform continues determining the number of objects running on the data platform at a previous version level of the application package. In response to determining the number of objects of the application instance running on the data platform at the previous version level of the application package is none, the data platform upgrades the application instance to the new version of the application package.

公开(公告)号：US12061717B2

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

申请号：US18062656

申请日：2022-12-07

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Khalid Zaman Bijon ,  Damien Carru ,  Thierry Cruanes ,  Vikas Jain ,  Zheng Mi ,  Subramanian Muralidhar

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/248 ,  G06F16/25 ,  G06F16/27 ,  G06F21/62

CPC classification number: G06F21/6227 ,  G06F16/221 ,  G06F16/2282 ,  G06F16/248 ,  G06F16/252 ,  G06F16/27

Abstract: A shared database platform implements dynamic masking on data shared between users where specific data is masked, transformed, or otherwise modified based on preconfigured functions that are associated with user roles. The shared database platform can implement the masking at runtime dynamically in response to users requesting access to a database object that is associated with one or more masking policies.

公开(公告)号：US20240176822A1

公开(公告)日：2024-05-30

申请号：US18428694

申请日：2024-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 database system facilitates secure data sharing by implementing projection constraints within a query processing framework. Upon receiving a query directed to a shared dataset, the system, utilizing hardware processors, identifies a subset of data within the dataset that is subject to a projection constraint policy. The applicability of the projection constraint is determined based on the context of the query, which is derived from a data sharing agreement. The system processes the query by selectively restricting the projection of data values from constrained columns, while allowing specific operations to be performed on the data. The output generated in response to the query is compliant with the projection constraint policy, providing derived data based on the allowed operations without revealing the actual data values. This ensures the confidentiality of sensitive information while enabling collaborative data analysis and sharing among various users of the database system.

公开(公告)号：US11989206B2

公开(公告)日：2024-05-21

申请号：US17815375

申请日：2022-07-27

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 database replication using replication preparation objects include storing, by at least one hardware processor, at least one task object at a remote deployment of a data provider. A replication request originating from an account of a data consumer is detected at the remote deployment using the at least one task object. The replication request is associated with a database available at a primary deployment of the data provider. Responsive to the detecting of the replication request, a local instance of the database is generated at the remote deployment. The account of the data consumer at the remote deployment is configured to access the local instance of the database.

公开(公告)号：US11909743B1

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

申请号：US18352059

申请日：2023-07-13

Applicant: Snowflake Inc.

Inventor： Christine A. Avanessians ,  Damien Carru ,  Ramachandran Natarajan Iyer ,  Dennis Edgar Lynch ,  Subramanian Muralidhar

IPC: H04L9/40

CPC classification number: H04L63/105 ,  H04L63/102

Abstract: Systems and methods for an organization-level account for an organization on a data platform, users of which can possess administrative or management privileges with respect to the organization and across one or more others accounts of the organization.

公开(公告)号：US20240054147A1

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

申请号：US18494599

申请日：2023-10-25

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Shreyas Narendra Desai ,  German Alberto Gil Echeverri ,  Prasanna Krishnan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Eric Robinson ,  Sahaj Saini

IPC: G06F16/27 ,  G06F16/22 ,  G06Q30/018 ,  G06Q30/0204 ,  G06F16/23

CPC classification number: G06F16/275 ,  G06F16/2282 ,  G06Q30/0185 ,  G06Q30/0205 ,  G06F16/2379

Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.

公开(公告)号：US20240004901A1

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

申请号：US18467876

申请日：2023-09-15

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Chao-Yang Lo ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini

IPC: G06F16/27 ,  G06F16/185 ,  G06F16/11 ,  G06F16/13

CPC classification number: G06F16/273 ,  G06F16/185 ,  G06F16/11 ,  G06F16/13

Abstract: A system for data object replication includes at least one hardware processor and at least one memory storing instructions. The instructions cause the at least one hardware processor to perform operations including parsing a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider. A dependency of the data object to one or more additional data objects stored in the set of databases is detected. A sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider is performed. The second deployment is identified by the replication request. A sequence of the sequential replication is based on the detected dependency.