-
公开(公告)号:US20230401334A1
公开(公告)日:2023-12-14
申请号:US18217163
申请日:2023-06-30
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Thierry Cruanes , Monica J. Holboke , Allison Waingold Lee , Subramanian Muralidhar , David Schultz
CPC classification number: G06F21/6245 , G06F21/53 , G06F2221/032
Abstract: A data platform creates an application in a data-provider account, where the application includes one or more application programming interfaces (APIs) corresponding to one or more underlying code blocks. The data platform shares homomorphically encrypted provider data with the application in the data-provider account. The data platform installs, in a data-consumer account, an application instance of the application. The data platform shares homomorphically encrypted consumer data with the application instance in the data-consumer account. The data platform 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, and which operate on the shared homomorphically encrypted provider data and the shared homomorphically encrypted consumer data. The data platform saves homomorphically encrypted output of the one or more respective associated underlying code blocks locally within the data-consumer account.
-
公开(公告)号:US11797497B2
公开(公告)日:2023-10-24
申请号:US18068998
申请日:2022-12-20
Applicant: Snowflake Inc.
Inventor: Damien Carru , Benoit Dageville , Subramanian Muralidhar , Eric Robinson , Sahaj Saini , David Schultz
CPC classification number: G06F16/212 , G06F16/285 , G06F21/6245
Abstract: Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. A bundle is a schema object with associated hidden schemas. A bundle can be created by a provider user and can be shared with a plurality of consumer users. The bundle can be used to enable code sharing and distribution without losing control while maintaining security protocols.
-
公开(公告)号:US11514057B2
公开(公告)日:2022-11-29
申请号:US17689463
申请日:2022-03-08
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Yujie Li , Zheng Mi , Subramanian Muralidhar , David Schultz
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.
-
公开(公告)号:US20220138342A1
公开(公告)日:2022-05-05
申请号:US17083732
申请日:2020-10-29
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Zheng Mi , Subramanian Muralidhar , David Schultz , Jian Xu
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.
-
公开(公告)号:US20250111083A1
公开(公告)日:2025-04-03
申请号:US18977758
申请日:2024-12-11
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Thierry Cruanes , Monica J. Holboke , Allison Waingold Lee , Subramanian Muralidhar , David Schultz
IPC: G06F21/62 , G06F9/54 , G06F16/2455 , G06F21/53
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.
-
公开(公告)号:US12216662B2
公开(公告)日:2025-02-04
申请号:US18447231
申请日:2023-08-09
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Yujie Li , Zheng Mi , Subramanian Muralidhar , David Schultz
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 target object identifier. The processor determines a target object associated with the target object identifier. The target object includes a tag value. The processor associates the current tag with the target object. The processor identifies a first child object of the target object. The target object and the first child object are hierarchical objects. In response to determining that the first child object is tag-unassociated, the processor associates the current tag with the first child object. In response to receiving a query including the tag name, the processor generates an output based on the tag name. Other embodiments are also described herein.
-
公开(公告)号: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.
-
公开(公告)号: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.
-
公开(公告)号:US20240378305A1
公开(公告)日:2024-11-14
申请号:US18316787
申请日:2023-05-12
Applicant: Snowflake Inc.
Inventor: Suraj P. Acharya , Jennifer Wenjun Bi , Khalid Zaman Bijon , Damien Carru , Lin Chan , Tianyi Chen , Jeremy Yujui Chen , Thierry Cruanes , Benoit Dageville , Simon Holm Jensen , Boxin Jiang , Dmitry A. Lychagin , Subramanian Muralidhar , Shuaishuai Nie , Eric Robinson , Sahaj Saini , David Schultz , Kevin Wang , Wenqi Wei , Zixi Zhang , Xingzhe Zhou
Abstract: Systems and methods for generating object references with selectable scopes are provided. The systems and methods perform operations including calling, by a first entity, a reference generator function using one or more arguments associated with a database object that the first entity is authorized to access according to a first set of access privileges, the one or more arguments comprising a scope definition that defines persistence of a reference. The operations include obtaining, from the reference generator function, a reference to the database object, the reference persisting according to the scope definition. The operations include passing the reference to a second entity to enable the second entity to perform one or more database operations on the database object according to a second set of access privileges derived from the first set of access privileges.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-