公开(公告)号：US20240028591A1

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

申请号：US18477694

申请日：2023-09-29

Applicant: Snowflake Inc

Inventor： Raja Suresh Krishna Balakrishnan ,  Thierry Cruanes ,  Yujie Li ,  Subramanian Muralidhar ,  David Schultz ,  Jiaqi Yan

IPC: G06F16/2453 ,  G06F21/53

CPC classification number: G06F16/24539 ,  G06F21/53 ,  G06F2221/034

Abstract: A data platform that implements memoizable functions for database objects. The data platform detects a first execution of a memoizable function and generates a first key based on metadata of one or more database objects operated on by the memoizable function and generates a first result for the memoizable function based on the one or more database objects. The data platform detects a second execution of the memoizable function and generates a second key based on the metadata of the one or more database objects operated on by the memoizable function. When the first key and the second key are equal, the data platform reuses the first result of the memoizable function. When the first key and second key do not match, the data platform generates a second result for the second execution of the memoizable function.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US11803432B1

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

申请号：US18051457

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Thierry Cruanes ,  Monica J. Holboke ,  Allison Waingold Lee ,  Subramanian Muralidhar ,  David Schultz

IPC: G06F9/54 ,  G06F16/2455 ,  G06F21/62

CPC classification number: G06F9/547 ,  G06F9/541 ,  G06F16/2456 ,  G06F21/6254

Abstract: In an embodiment, a data platform creates an application in a data-provider account. The application includes one or more APIs corresponding to one or more underlying code blocks. The data platform shares provider data with the application in the data-provider account, and also installs, in a data-consumer account, an application instance of the application. The application instance includes one or more APIs corresponding to the one or more APIs in the application in the data-provider account. The data platform shares consumer data with the application instance in the data-consumer account, and invokes one or more of the APIs of the application instance to execute respective associated underlying code blocks, which are not visible to the data-consumer account. The data platform also saves output of the one or more respective associated underlying code blocks locally within the data-consumer account.

公开(公告)号：US11775563B2

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

申请号：US17809931

申请日：2022-06-30

Applicant: Snowflake Inc.

Inventor： Dhiraj Gupta ,  Subramanian Muralidhar

IPC: G06F16/00 ,  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.

公开(公告)号：US20230297591A1

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

申请号：US18324787

申请日：2023-05-26

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/27 ,  G06F16/21 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F16/213 ,  G06F16/256

Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.

公开(公告)号：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.

公开(公告)号：US20230214405A1

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

申请号：US18119775

申请日：2023-03-09

Applicant: Snowflake Inc.

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

IPC: G06F16/27 ,  G06F16/955 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F16/9566 ,  G06F16/254

Abstract: The embodiments described herein provide means for replicating external stages between deployments of e.g., a cloud data lake using a modified storage integration. The modified storage integration may be defined with a set of storage locations, wherein the storage integration comprises a base URL for each of the set of storage locations and wherein each storage location identifies a remote deployment where a cloud platform is hosted and a geographic region of the remote deployment. An external stage object may be bound to the storage integration, wherein the external stage object facilitates a data loading operation that is currently in progress on the first storage location. In response to detecting an outage at the first storage location, the data loading operation that was in progress on the first storage location may be continued at the second storage location using the storage integration.

公开(公告)号：US20230214383A1

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

申请号：US18181423

申请日：2023-03-09

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Khalid Zaman Bijon ,  Subramanian Muralidhar ,  David Schultz ,  Jian Xu

IPC: G06F16/23

CPC classification number: G06F16/2365 ,  G06F16/2358

Abstract: Aspects of the present disclosure address systems, methods, and devices for tracking object dependencies in a cloud database system. An object dependency created between a referencing object and a referenced object is detected. Based on detecting the object dependency, a dependency record is generated. The dependency record includes dependency information describing the object dependency between the reference object and the referenced object. The dependency record is stored in a database of dependency records.