-
公开(公告)号:US11811639B2
公开(公告)日:2023-11-07
申请号:US18061218
申请日:2022-12-02
Applicant: Snowflake Inc.
Inventor: Jonathan C. Allie , Seth Hettich , Aaron S. Joyner
IPC: H04L43/50 , H04L67/02 , H04L67/133 , H04L43/0817 , H04L61/4541 , H04L61/4511 , H04L67/1036 , H04L43/0805
CPC classification number: H04L43/50 , H04L43/0805 , H04L43/0817 , H04L61/4511 , H04L61/4541 , H04L67/02 , H04L67/1036 , H04L67/133
Abstract: A system may include a processing device and a memory storing instructions that, when executed by the processing device, causes the processing device to discover one or more endpoints of a service in view of a name that is unique to the service. In response to receiving a request to resolve the name from a client, the processing device may obtain the one or more endpoints of that service in view of the name. The processing device may filter the one or more endpoints, in view of the name and return the one or more endpoints which are filtered, to the client.
-
公开(公告)号:US11809916B2
公开(公告)日:2023-11-07
申请号:US17647752
申请日:2022-01-12
Applicant: Snowflake Inc.
Inventor: Chen Luo , Alexander Miller , William Waddington
CPC classification number: G06F9/524 , G06F16/2343 , G06F16/2379 , G06F16/256
Abstract: The subject technology performs a locking operation on a first set of keys by a first statement of a first transaction. The subject technology determines that a conflict occurred between the first statement and a second transaction. The subject technology determines that the second transaction has yet to complete after a predetermined period of time. The subject technology performs a deadlock detection process where the subject technology stores a key and value in a table indicating the first transaction and the second transaction, detects, based at least in part on a graph traversal of the table starting from the first transaction, a cycle between the first transaction and the second transaction, and determines that the first transaction is a youngest transaction in the detected cycle. The subject technology ceases execution of the first transaction in response to the first transaction being a youngest transaction in a detected cycle.
-
公开(公告)号: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.
-
公开(公告)号:US20230350921A1
公开(公告)日:2023-11-02
申请号:US17661162
申请日:2022-04-28
Applicant: Snowflake Inc.
Inventor: Joshua Slocum , Evan J. Tschannen
IPC: G06F16/28 , G06F16/22 , G06F16/2458 , G06F16/27
CPC classification number: G06F16/283 , G06F16/2282 , G06F16/289 , G06F16/2477 , G06F16/27
Abstract: A distributed database system can include transactional database and an object storage database. The data of the transactional database can be split into granules and replicated to the object storage database. The distributed database system can process transactional requests using the transactional database. The distributed database can receive a request that reads data more than a set size from the transactional database. The distributed database system can identify the granule data in the object storage database and transmit data to complete the read on one or more of a plurality of execution nodes.
-
公开(公告)号:US11805167B2
公开(公告)日:2023-10-31
申请号:US17244616
申请日:2021-04-29
Applicant: SNOWFLAKE INC.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
CPC classification number: H04L67/10 , G06F16/2379 , G06F21/6272 , H04L41/5096 , H04L63/0272 , H04L63/10 , H04L63/101 , H04L67/1097 , H04L67/51 , H04L67/53
Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include creating a listing in a data exchange, the listing including a data set hosted by a first cloud computing entity. The data set can be shared with a second cloud computing entity. The method further includes receiving a request associated with a customer account of the second cloud computing entity to access the data set of the listing hosted by the first cloud computing entity and replicating at least a subset of the data set of the listing from the first cloud computing entity to a provider account at the second cloud computing entity to be accessible by the customer account at the second cloud computing entity.
-
公开(公告)号:US20230342377A1
公开(公告)日:2023-10-26
申请号:US18345949
申请日:2023-06-30
Applicant: Snowflake Inc.
Inventor: Istvan Cseri , Tyler Jones , Daniel E. Sotolongo , Boyuan Zhang
IPC: G06F16/27
CPC classification number: G06F16/27
Abstract: Techniques described herein can enable stream replication. A first deployment can store a table including one or more streams. The techniques described herein can be used to replicate the table at a second deployment while replicating the one or more streams associated with the table. Select prior table versions and partitions in the table are copied to the second deployment to enable stream replication.
-
公开(公告)号:US20230334167A1
公开(公告)日:2023-10-19
申请号: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 , G06F21/604 , G06F16/2282 , 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.
-
公开(公告)号:US20230334166A1
公开(公告)日:2023-10-19
申请号:US18343361
申请日:2023-06-28
Applicant: SNOWFLAKE INC.
Inventor: Benoit Dageville , Thierry Cruanes , Martin Hentschel , Peter Povinec
CPC classification number: G06F21/6218 , G06F16/256 , G06F2221/2145
Abstract: A method of sharing data in a multi-tenant database includes inspecting, by a processing device of a multiple tenant database, a sharer account to determine an existence of a link between an alias object in a target account and a database, wherein the database is linked to a first role object included in a share object in the sharer account. The method includes granting a second role object, in the target account, access rights to the alias object, wherein the first role object having one or more grants to one or more resources of the sharer account, and wherein the target account accesses the one or more resources using the one or more grants of the share object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.
-
公开(公告)号:US20230315755A1
公开(公告)日:2023-10-05
申请号:US18103977
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Tyler Arthur Akidau , Istvan Cseri , Tyler Jones , Dinesh Chandrakant Kulkarni , Daniel Mills , Daniel E. Sotolongo , Di Fei Zhang
IPC: G06F16/27
CPC classification number: G06F16/273
Abstract: Techniques for triggering pipeline execution based on data change (transaction commit) are described. The pipelines can be used for data ingestion or other specified tasks. These tasks can be operational across account, organization, cloud region, and cloud provider boundaries. The tasks can be triggered by commit post-processing. Gates in the tasks can be set up to reference change data capture information. If the gate is satisfied, tasks can be executed to set up data pipelines.
-
-
-
-
-
-
-
-
-