-
公开(公告)号:US12101294B2
公开(公告)日:2024-09-24
申请号:US18341954
申请日:2023-06-27
申请人: Snowflake Inc.
IPC分类号: H04L9/40
CPC分类号: H04L63/0218 , H04L63/0236 , H04L63/0245
摘要: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.
-
公开(公告)号:US20240176711A1
公开(公告)日:2024-05-30
申请号:US18329348
申请日:2023-06-05
申请人: Snowflake Inc.
发明人: Loc Duc Bui , Hitesh Madan , Nithin Mahesh , Subramanian Muralidhar , Sahaj Saini , Di Wu
CPC分类号: G06F11/203 , G06F16/256 , G06F16/27
摘要: The subject technology determines a set of share objects in a replication group. The subject technology, for each object from the set of share objects, determines a set of permissions for a set of objects of databases that has been granted to each share object from the replication group. The subject technology, for each permission from the set of permissions, determines a set of dependencies, the set of dependencies comprising a second set of objects. The subject technology generates a graph structure based at least in part on the set of share objects, the set of permissions, and the set of dependencies. The subject technology traverses at least a portion of the graph structure to determine a final set of dependencies for replication. The subject technology performs a replication process based at least in part on the final set of dependencies.
-
公开(公告)号:US20230297591A1
公开(公告)日:2023-09-21
申请号:US18324787
申请日:2023-05-26
申请人: 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
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.
-
公开(公告)号:US11586515B1
公开(公告)日:2023-02-21
申请号:US17663941
申请日:2022-05-18
申请人: Snowflake Inc.
发明人: Abdullah Al Mahmood , Ruta Dhaneshwar , Xin Huang , Ganeshan Ramachandran Iyer , Jiaxing Liang , Nithin Mahesh , Raghav Ramachandran , Purav B. Saraiya , Yanyi Zhang
摘要: Described herein are techniques for improving disaster recovery, in particular disaster recovery pertaining to data transfer requests. The data transfer request can be received by each of multiple deployments; however, only a primary deployment can process the request. The data transferred by the primary deployment may be replicated in the secondary deployments. In response to a failover event, one of the secondary deployments can be designated as the new primary development and continue the data transfer based on the data transfer request and the replication information received from the old primary deployment prior to the failover.
-
公开(公告)号:US11372891B2
公开(公告)日:2022-06-28
申请号: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
摘要: A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor then 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.
-
公开(公告)号:US20210281544A1
公开(公告)日:2021-09-09
申请号:US17156072
申请日:2021-01-22
申请人: Snowflake Inc.
IPC分类号: H04L29/06
摘要: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.
-
公开(公告)号:US10999261B1
公开(公告)日:2021-05-04
申请号:US17086261
申请日:2020-10-30
申请人: Snowflake Inc.
发明人: Damien Carru , Robert Bengt Benedikt Gernhardt , Martin Hentschel , Nithin Mahesh , Eric Robinson
摘要: 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.
-
公开(公告)号:US10938780B1
公开(公告)日:2021-03-02
申请号:US16809209
申请日:2020-03-04
申请人: Snowflake Inc.
IPC分类号: H04L29/06
摘要: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.
-
公开(公告)号:US20240289333A1
公开(公告)日:2024-08-29
申请号:US18656126
申请日:2024-05-06
申请人: Snowflake Inc.
发明人: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
IPC分类号: G06F16/2453 , G06F7/14 , G06F16/22 , G06F16/23 , G06F21/62
CPC分类号: G06F16/24549 , G06F7/14 , G06F16/2228 , G06F16/2379 , G06F21/6218 , G06F21/6227
摘要: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US11983165B1
公开(公告)日:2024-05-14
申请号:US18128212
申请日:2023-03-29
申请人: Snowflake Inc.
发明人: Abdullah Al Mahmood , Chong Han , Ganeshan Ramachandran Iyer , Jiaxing Liang , Nithin Mahesh , Yanrui Zhang
IPC分类号: G06F16/23 , G06F16/174 , G06F16/27
CPC分类号: G06F16/2365 , G06F16/1748 , G06F16/27
摘要: Embodiments of the present disclosure provide techniques for deduplicating files during internal stage replication using a directory table of the replicated internal stage that is modified as a cache for storing and retrieving original file-level metadata for the replicated files. An initial list of candidate files for loading from the internal stage to a table of the target deployment is prepared based on the files listed in the internal stage, and refined using a directory table lookup. If there is any inconsistency between the files registered in the directory table and the files listed in the internal stage, the target deployment will inspect the user-defined file-level metadata to obtain original file-level metadata for each file that is present in the internal stage but not in the directory table. This information may be used during deduplication to ensure that no duplicate files are loaded.
-
-
-
-
-
-
-
-
-