公开(公告)号：US12259991B2

公开(公告)日：2025-03-25

申请号：US18394531

申请日：2023-12-22

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Jashua Gupta ,  Jian Xu

IPC: G06F21/62

Abstract: Methods of referencing row access policy (RAP) protected mapping tables in a RAP for a data table are disclosed herein. An example method of referencing a mapping table in a data table using nested RAP includes defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions. The processing device further defines a second access policy attached to the data table referencing the mapping table. The processing device in response to a query, executes the second access policy of the data table to provide a response or operation of data associated with the data table and the mapping table. Executing the second access policy invokes executing the first access policy of the mapping table. The executing of both the second access policy of the data table and the first access policy of the mapping table are recorded.

公开(公告)号：US20230032281A1

公开(公告)日：2023-02-02

申请号：US17659797

申请日：2022-04-19

Applicant: Snowflake Inc.

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

IPC: G06F16/242 ,  G06F16/23 ,  G06F16/22 ,  G06F16/21 ,  G06F16/2453

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.

公开(公告)号：US11868496B1

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

申请号：US18227781

申请日：2023-07-28

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Jashua Gupta ,  Jian Xu

IPC: G06F21/62

CPC classification number: G06F21/6218

Abstract: This disclosure provides methods and techniques of referencing row access policy (RAP) protected mapping tables in a RAP for a data table are disclosed herein. An example method of referencing a mapping table in a data table using nested RAP includes defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions. The processing device further defines a second access policy attached to the data table referencing the mapping table. The processing device in response to a query, executes the second access policy of the data table to provide a response or operation of data associated with the data table and the mapping table. Executing the second access policy invokes executing the first access policy of the mapping table.

公开(公告)号：US11880491B2

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

申请号：US18161574

申请日：2023-01-30

Applicant: Snowflake Inc.

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

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

CPC classification number: G06F21/6254 ,  G06F16/245 ,  G06F16/284

Abstract: Various embodiments provide for tag-based application of a masking policy, which can be used in connection with a data platform. In particular, various embodiments enable enforcement of one or more masking policies against an entity (e.g., object) of a data platform, such as a database, a table, a row, or a column, based on one or more tags associated with the entity.

公开(公告)号：US20240427924A1

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

申请号：US18823014

申请日：2024-09-03

Applicant: Snowflake Inc.

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

IPC: G06F21/62

Abstract: Systems and methods for managing column hiding are provided. The systems and methods receive, from a client device, a query associated with a table. The systems and methods determine an access restriction associated with the client device. The systems and methods identify a column of the table that is restricted by the access restriction associated with the client device. In response to identifying the column of the table that is restricted by the access restriction associated with the client device, the systems and methods provide a result of the query that excludes data corresponding to the column.

公开(公告)号：US20240419828A1

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

申请号：US18394531

申请日：2023-12-22

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Jashua Gupta ,  Jian Xu

IPC: G06F21/62

Abstract: Methods of referencing row access policy (RAP) protected mapping tables in a RAP for a data table are disclosed herein. An example method of referencing a mapping table in a data table using nested RAP includes defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions. The processing device further defines a second access policy attached to the data table referencing the mapping table. The processing device in response to a query, executes the second access policy of the data table to provide a response or operation of data associated with the data table and the mapping table. Executing the second access policy invokes executing the first access policy of the mapping table. The executing of both the second access policy of the data table and the first access policy of the mapping table are recorded.

公开(公告)号：US20240403276A1

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

申请号：US18326158

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Hossein Ahmadi ,  Raja Suresh Krishna Balakrishnan ,  David Schultz ,  Jian Xu ,  Yunqiao Zhang

IPC: G06F16/215 ,  G06F16/22

Abstract: Described herein are techniques for data quality monitoring in a network-based data system. A data metric function used to evaluate data quality can be stored, where the data metric function is defined as schema level object. The data metric function can be attached to a table associated with an account and is evaluated on data associates with the table to generate evaluation results. The evaluation results can be stored in an account-specific central database, from which access is provided to the evaluation results to a user for the account.

公开(公告)号：US20240168946A1

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

申请号：US18428371

申请日：2024-01-31

Applicant: Snowflake Inc.

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

IPC: G06F16/242 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453

CPC classification number: G06F16/2445 ,  G06F16/211 ,  G06F16/2291 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/2453

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.

公开(公告)号：US11928108B2

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

申请号：US18181423

申请日：2023-03-09

Applicant: Snowflake Inc.

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

IPC: G06F16/242 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453

CPC classification number: G06F16/2445 ,  G06F16/211 ,  G06F16/2291 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/2453

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.

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