-
公开(公告)号: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.
-
公开(公告)号:US12169580B2
公开(公告)日:2024-12-17
申请号:US18497179
申请日:2023-10-30
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Peter Povinec
Abstract: Using container-centric managed access, an administrator is enabled to define a set of future grants for each object that will be created in the future in a container managed by the administrator. When a user creates a database object, the system checks the future grants to determine if any apply to the user, the database object, or the combination. Any applicable future grants are applied to the database object before the user is allowed to modify it. As a result, the administrator is enabled to control the privileges associated with the database object even before the database object is created, while restricting individual object owners from managing privileges on their owned objects.
-
公开(公告)号:US20240061948A1
公开(公告)日:2024-02-22
申请号:US18497179
申请日:2023-10-30
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijion , Peter Povinec
CPC classification number: G06F21/6218 , G06F16/27
Abstract: Using container-centric managed access, an administrator is enabled to define a set of future grants for each object that will be created in the future in a container managed by the administrator. When a user creates a database object, the system checks the future grants to determine if any apply to the user, the database object, or the combination. Any applicable future grants are applied to the database object before the user is allowed to modify it. As a result, the administrator is enabled to control the privileges associated with the database object even before the database object is created, while restricting individual object owners from managing privileges on their owned objects.
-
公开(公告)号: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.
-
公开(公告)号: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
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.
-
公开(公告)号:US20230177210A1
公开(公告)日:2023-06-08
申请号:US18162506
申请日:2023-01-31
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.
-
公开(公告)号:US20230102349A1
公开(公告)日:2023-03-30
申请号:US18062656
申请日:2022-12-07
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Damien Carru , Thierry Cruanes , Vikas Jain , Zheng Mi , Subramanian Muralidhar
IPC: G06F21/62 , G06F16/22 , G06F16/27 , G06F16/25 , G06F16/248
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.
-
公开(公告)号:US20230022027A1
公开(公告)日:2023-01-26
申请号:US17936681
申请日:2022-09-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.
-
公开(公告)号:US11544399B2
公开(公告)日:2023-01-03
申请号:US17657578
申请日:2022-03-31
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Peter Povinec
Abstract: Using container-centric managed access, an administrator is enabled to define a set of future grants for each object that will be created in the future in a container managed by the administrator. When a user creates a database object, the system checks the future grants to determine if any apply to the user, the database object, or the combination. Any applicable future grants are applied to the database object before the user is allowed to modify it. As a result, the administrator is enabled to control the privileges associated with the database object even before the database object is created, while restricting individual object owners from managing privileges on their owned objects.
-
-
-
-
-
-
-
-
-