-
公开(公告)号:US11934543B1
公开(公告)日:2024-03-19
申请号:US18056489
申请日:2022-11-17
Applicant: Snowflake Inc.
Inventor: Jennifer Wenjun Bi , Khalid Zaman Bijon , Damien Carru , Thierry Cruanes , Simon Holm Jensen , Daniel N. Meredith , Subramanian Muralidhar , Eric Robinson , David Schultz , Zixi Zhang
CPC classification number: G06F21/604 , G06F21/6227 , G06F2221/2113 , G06F2221/2141
Abstract: Systems and methods for generating transient object references are provided. The systems and methods perform operations including establishing a session between a first entity and a second entity. The operations include identifying an object that the first entity is authorized to access according to a first set of access privileges. The operations include generating a reference associated with the object. The operations include temporarily authorizing the second entity to access the object using the reference according to a second set of access privileges, the second set of access privileges being derived from the first set of access privileges.
-
公开(公告)号:US20240086381A1
公开(公告)日:2024-03-14
申请号:US18513163
申请日:2023-11-17
Applicant: Snowflake Inc.
IPC: G06F16/215 , G06F16/2455 , G06F16/2457 , G06F16/248
CPC classification number: G06F16/215 , G06F16/24552 , G06F16/24573 , G06F16/248
Abstract: Disclosed are techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein each of the set of bloom filters is built with a number of hash functions that is based on a desired false positive rate. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested, identifying using the set of bloom filters, candidate files from the set of candidate files that are duplicative of a file in the first set of files and pruning from the set of candidate files, each candidate file identified as being duplicative of a file in the first set of files using the set of bloom filters.
-
公开(公告)号:US11868502B2
公开(公告)日:2024-01-09
申请号:US18341935
申请日:2023-06-27
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.
-
公开(公告)号:US11853274B2
公开(公告)日:2023-12-26
申请号:US17971482
申请日:2022-10-21
Applicant: Snowflake Inc.
IPC: G06F16/00 , G06F16/215 , G06F16/248 , G06F16/2455 , G06F16/2457
CPC classification number: G06F16/215 , G06F16/248 , G06F16/24552 , G06F16/24573
Abstract: Disclosed are techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein the data exchange includes a metadata storage where metadata including a list of files ingested is stored. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested into the data exchange, the set of bloom filters may be used to identify from within the set of candidate files, each candidate file that is duplicative of a file in the first set of files.
-
公开(公告)号:US20230409639A1
公开(公告)日:2023-12-21
申请号:US18104271
申请日:2023-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 system for enforcing projection constraints on data values stored in specified variables of a shared dataset of a cloud data platform. A request is received from a first account of the cloud data platform that identifies a first operation to be performed on the shared dataset. A first set of data, including data accessed from a first variable, is accessed from the shared dataset to use in performing the first operation. A projection constraint policy attached to the first variable of the shared dataset is determined, and the projection constraint policy is further determined to be enforced based on the request. Based on the first set of data and the first operation, an output to the first request is generated.
-
公开(公告)号:US20230401329A1
公开(公告)日:2023-12-14
申请号:US17933761
申请日:2022-09-20
Applicant: Snowflake Inc.
Inventor: Subramanian Muralidhar , Polita Paulus , Saurin Shah , Srinidhi Karthik Bisthavalli Srinivasa
CPC classification number: G06F21/6218 , G06F16/211
Abstract: Provided herein are systems and methods for sharing unstructured data in stages. For example, a method includes generating a share object at an account of a data provider. The share object identifies an account of a data consumer and at least one unstructured data file shared with the account of the data consumer. The share object is configured with access privileges to the at least one unstructured data file. A notification of the share object is communicated to the account of the data consumer.
-
公开(公告)号:US20230401185A1
公开(公告)日:2023-12-14
申请号:US18112934
申请日:2023-02-22
Applicant: Snowflake Inc.
Inventor: Orestis Kostakis , Prasanna V. Krishnan , Subramanian Muralidhar , Shakhina Pulatova , Megan Marie Schoendorf
IPC: G06F16/215 , G06F16/2457 , G06F16/25 , G06F16/176
CPC classification number: G06F16/215 , G06F16/24578 , G06F16/256 , G06F16/176
Abstract: A set of affinity metrics may be determined for a set of listings, each listing of the set of listings comprising data to be shared through a data exchange, wherein the set of affinity metrics includes a set of characteristics allowing identification of a listing having one or more characteristics in the set of characteristics. For each pair of listings of the set of listings, an affinity score can be calculated, using the set of affinity metrics, and stored as part of the record in an affinity store. One or more listings of the set of listings using the affinity score between the first listing of the set of listings and the one or more listings of the set of listings can be presented.
-
公开(公告)号:US11841877B2
公开(公告)日:2023-12-12
申请号:US17807956
申请日:2022-06-21
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/23 , G06F16/22 , G06Q30/018 , G06Q30/0204
CPC classification number: G06F16/275 , G06F16/2282 , G06F16/2379 , G06Q30/0185 , G06Q30/0205
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.
-
公开(公告)号:US11809591B1
公开(公告)日:2023-11-07
申请号:US18172404
申请日:2023-02-22
Applicant: Snowflake Inc.
Inventor: Raja Suresh Krishna Balakrishnan , Khalid Zaman Bijon , Subramanian Muralidhar , David Schultz , Jian Xu
CPC classification number: G06F21/6227 , G06F2221/2141
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.
-
公开(公告)号:US11809425B1
公开(公告)日:2023-11-07
申请号:US17819758
申请日:2022-08-15
Applicant: Snowflake Inc.
Inventor: Raja Suresh Krishna Balakrishnan , Thierry Cruanes , Yujie Li , Subramanian Muralidhar , David Schultz , Jiaqi Yan
IPC: H04L29/06 , 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.
-
-
-
-
-
-
-
-
-