-
公开(公告)号:US20220318269A1
公开(公告)日:2022-10-06
申请号: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
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.
-
公开(公告)号:US20220292115A1
公开(公告)日:2022-09-15
申请号:US17804753
申请日:2022-05-31
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
Abstract: A system for sub-table replication within a materialized view of a source data table. A materialized view of a source data table is generated based on a query, the source data table having a plurality of data table rows associated with a plurality of client identifiers and including an entitlements column and data content, the entitlements column including a plurality of provider account identifiers and a plurality of consumer account identifiers. An update to an entitlements table of the source data table is detected where the entitlements table includes a plurality of entitlements table rows and where the entitlements table rows are associated with the client identifiers, the consumer account identifiers, and the provider account identifiers. An update to the source data table based on the first update to the entitlements table is detected, and an incremental replication of the materialized view of the source data table is performed.
-
公开(公告)号:US11374908B2
公开(公告)日:2022-06-28
申请号:US17644854
申请日:2021-12-17
Applicant: Snowflake Inc.
Inventor: Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Eric Robinson , Rodney Weaver
Abstract: A network device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences messages, such as replication data, over a channel comprising a plurality of private network nodes. The messages can be generated and encrypted using one or more key pairs and changing wrapping replication keys to send and receive the messages between different types of database deployments.
-
公开(公告)号:US11223603B2
公开(公告)日:2022-01-11
申请号:US17463338
申请日:2021-08-31
Applicant: Snowflake Inc.
Inventor: Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Eric Robinson , Rodney Weaver
Abstract: A network device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences messages, such as replication data, over a channel comprising a plurality of private network nodes. The messages can be generated and encrypted using one or more key pairs and changing wrapping replication keys to send and receive the messages between different types of database deployments.
-
公开(公告)号:US11055315B1
公开(公告)日:2021-07-06
申请号:US16944988
申请日:2020-07-31
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
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.
-
公开(公告)号:US10862873B1
公开(公告)日:2020-12-08
申请号:US16863191
申请日:2020-04-30
Applicant: Snowflake Inc.
Inventor: Damien Carru , Robert Bengt Benedikt Gernhardt , Martin Hentschel , Nithin Mahesh , Eric Robinson
Abstract: A networked device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences of messages, such as replicated data, using one or more keypairs and wrapping keys. The sequences of messages can include an initial set of messages that are encrypted by a wrapping key, and further include another set of messages that are encrypted by a replaced staggered key. The sequence of messages can be configured to be decrypted without exporting keys of hardware security modules.
-
公开(公告)号:US20200301942A1
公开(公告)日:2020-09-24
申请号:US16357822
申请日:2019-03-19
Applicant: Snowflake Inc.
Inventor: Eric Robinson , Benoit Dageville , Shigeyuki Takeda , Kristopher Wagner
Abstract: Systems, methods, and devices for transitioning a client connection for a database from a first deployment of the database to a second deployment of the database. A method includes maintaining the client connection between a client and the first deployment such that database traffic occurs at the first deployment. The method includes generating a unique identification that references a first connection object of the first deployment and a second connection object of a second deployment. The method includes receiving a notification that the first deployment is unavailable and providing an external connection group unique identification to the second deployment for the second deployment to determine whether the client should be connected to the second deployment. The method includes receiving a uniform resource locator from the second deployment if the client should be connected to the second deployment.
-
公开(公告)号:US20250053576A1
公开(公告)日:2025-02-13
申请号:US18931781
申请日:2024-10-30
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Eric Robinson , Martin Hentschel
IPC: G06F16/27 , G06F16/245 , H04L67/1097
Abstract: Systems of methods of directing requests to databases based on client account association is disclosed. A method includes determining a first client account associated with a first request to perform a first transaction. The method includes determining a second client account associated with a second request to perform a second transaction. The method includes selecting, for the first request, a primary deployment that stores a first dataset responsive to determining the first client account associated with the first request. The method includes selecting, for the second request, a secondary deployment that stores a second dataset that includes the first dataset responsive to determining the second client account associated with the second request. The method includes executing, while the primary deployment and the secondary deployment are both available, the first transaction on the first dataset at the primary deployment and the second transaction on the second dataset at the secondary deployment.
-
公开(公告)号:US12210492B2
公开(公告)日:2025-01-28
申请号:US18456644
申请日:2023-08-28
Applicant: Snowflake Inc.
Inventor: Damien Carru , Benoit Dageville , Subramanian Muralidhar , Eric Robinson , Sahaj Saini , David Schultz
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.
-
公开(公告)号:US20250013453A1
公开(公告)日:2025-01-09
申请号:US18348490
申请日:2023-07-07
Applicant: Snowflake Inc.
Inventor: Tianyi Chen , Benoit Dageville , Subramanian Muralidhar , Shuaishuai Nie , Eric Robinson , Sahaj Saini
Abstract: Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. The bundle includes an interface directly accessible to the consumer account and a hidden bundle schema not directly accessible by the consumer account. A consumer account can upgrade from a first version to a second version by way of an intermediate version.
-
-
-
-
-
-
-
-
-