公开(公告)号：US11748374B2

公开(公告)日：2023-09-05

申请号：US17457751

申请日：2021-12-06

申请人： Snowflake Inc.

发明人： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Laxman Mamidi ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini

IPC分类号： G06F16/00 ,  G06F16/27 ,  G06F11/14 ,  G06F16/25 ,  G06F11/20 ,  G06F16/182 ,  G06F16/13 ,  G06F16/178 ,  G06F16/11

CPC分类号： G06F16/27 ,  G06F11/1461 ,  G06F11/1464 ,  G06F11/2023 ,  G06F11/2097 ,  G06F16/128 ,  G06F16/137 ,  G06F16/1787 ,  G06F16/184 ,  G06F16/1827 ,  G06F16/1844 ,  G06F16/256

摘要： Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.

公开(公告)号：US11704338B1

公开(公告)日：2023-07-18

申请号：US17652721

申请日：2022-02-28

申请人： Snowflake Inc.

发明人： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini ,  Chieh-Sheng Wang ,  Di Wu

IPC分类号： G06F16/30 ,  G06F16/27 ,  G06F16/25 ,  G06F16/21

CPC分类号： G06F16/27 ,  G06F16/213 ,  G06F16/256

摘要： Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.

公开(公告)号：US11704199B1

公开(公告)日：2023-07-18

申请号：US17823690

申请日：2022-08-31

申请人： Snowflake Inc.

发明人： Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Sahaj Saini ,  Matthew Uhlar

IPC分类号： G06F16/25 ,  G06F16/27 ,  G06F11/14

CPC分类号： G06F11/1435 ,  G06F16/256 ,  G06F16/27 ,  G06F2201/84

摘要： This disclosure provides methods and techniques of data replication involving cross replication group (RG) references. The present disclosure avoids automatic replication failing when an entity in an RG refers to another entity external to the RG. The entity to be replicated within the RG is referred to as the “referring entity,” and the entity as the dangling reference is referred to as the “referred entity.” Although the referring and referred entities are not replicated together in a replication operation, the referred entity may have already been replicated to the target account in another replication operation on a different replication group. In such cases, the data replication procedure may, according to aspects of the present disclosure, check if the referred entity has already been replicated, and if so, proceed to replicate the referring entity without fail, and link the referring and referred entities to enable normal functioning of the referring entity.

公开(公告)号：US20230205735A1

公开(公告)日：2023-06-29

申请号：US18179793

申请日：2023-03-07

申请人： Snowflake Inc.

发明人： Lin Chan ,  Tianyi Chen ,  Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Eric Robinson

IPC分类号： G06F16/14 ,  G06F16/16

CPC分类号： G06F16/148 ,  G06F16/164

摘要： Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.

公开(公告)号：US20230169090A1

公开(公告)日：2023-06-01

申请号：US17457751

申请日：2021-12-06

申请人： Snowflake Inc.

发明人： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Laxman Mamidi ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini

IPC分类号： G06F16/27 ,  G06F11/14 ,  G06F11/20 ,  G06F16/25

CPC分类号： G06F16/27 ,  G06F11/1464 ,  G06F11/1461 ,  G06F11/2023 ,  G06F16/256

摘要： Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.

公开(公告)号：US20220217125A1

公开(公告)日：2022-07-07

申请号：US17656620

申请日：2022-03-25

申请人： Snowflake Inc.

发明人： Damien Carru ,  Robert Bengt Benedikt Gernhardt ,  Martin Hentschel ,  Nithin Mahesh ,  Eric Robinson

IPC分类号： H04L9/40 ,  H04L9/08 ,  G06F16/27 ,  H04L9/30

摘要： 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.

公开(公告)号：US11290433B2

公开(公告)日：2022-03-29

申请号：US17219700

申请日：2021-03-31

申请人： Snowflake Inc.

发明人： Damien Carru ,  Robert Bengt Benedikt Gernhardt ,  Martin Hentschel ,  Nithin Mahesh ,  Eric Robinson

IPC分类号： H04L29/06 ,  H04L9/08 ,  G06F16/27 ,  H04L9/30

摘要： 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.

公开(公告)号：US20210374158A1

公开(公告)日：2021-12-02

申请号：US17226141

申请日：2021-04-09

申请人： Snowflake Inc.

发明人： 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/22 ,  G06Q30/00 ,  G06Q30/02 ,  G06F16/23

摘要： A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor filters of a data table based on the first update. The processor then detects a second update to the entitlements table and performs incremental replication of the data table by causing a full inventory replication at a next refresh to be executed for provider accounts associated with the provider account identifiers in the entitlements table. Other embodiments are also described herein.

公开(公告)号：US20240054147A1

公开(公告)日：2024-02-15

申请号：US18494599

申请日：2023-10-25

申请人： Snowflake Inc.

发明人： 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/22 ,  G06Q30/018 ,  G06Q30/0204 ,  G06F16/23

CPC分类号： G06F16/275 ,  G06F16/2282 ,  G06Q30/0185 ,  G06Q30/0205 ,  G06F16/2379

摘要： 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.

公开(公告)号：US20240004901A1

公开(公告)日：2024-01-04

申请号：US18467876

申请日：2023-09-15

申请人： Snowflake Inc.

发明人： Robert Bengt Benedikt Gernhardt ,  Chao-Yang Lo ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini

IPC分类号： G06F16/27 ,  G06F16/185 ,  G06F16/11 ,  G06F16/13

CPC分类号： G06F16/273 ,  G06F16/185 ,  G06F16/11 ,  G06F16/13

摘要： A system for data object replication includes at least one hardware processor and at least one memory storing instructions. The instructions cause the at least one hardware processor to perform operations including parsing a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider. A dependency of the data object to one or more additional data objects stored in the set of databases is detected. A sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider is performed. The second deployment is identified by the replication request. A sequence of the sequential replication is based on the detected dependency.