-
公开(公告)号:US10534792B2
公开(公告)日:2020-01-14
申请号:US14626853
申请日:2015-02-19
申请人: SNOWFLAKE INC.
IPC分类号: G06F17/30 , G06F16/27 , G06F9/50 , G06F16/14 , G06F16/21 , G06F16/22 , G06F16/951 , G06F16/182 , G06F16/23 , G06F16/2455 , G06F16/2458 , G06F16/9535 , G06F16/2453 , G06F9/48 , H04L29/08
摘要: A system and method for managing data storage and data access with querying data in a distributed system without buffering the results on intermediate operations in disk storage.
-
公开(公告)号:US20240323194A1
公开(公告)日:2024-09-26
申请号:US18673681
申请日:2024-05-24
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC分类号: H04L9/40 , G06F16/2455 , G06F21/60 , G06F21/62 , H04L41/22 , H04L51/212 , H04L67/1097
CPC分类号: H04L63/102 , G06F16/2455 , G06F21/606 , G06F21/6218 , H04L41/22 , H04L51/212 , H04L63/101 , H04L67/1097
摘要: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes creating, in a first data exchange belonging to a first data provider, a first listing. The method further comprises creating, in a second data exchange belonging to a second data provider, a second listing, the second listing comprising a tunnel to the first listing. The method also includes generating, in the second data exchange, a third listing, the third listing comprising data from the second listing and additional data from the second data provider.
-
公开(公告)号:US20240303252A1
公开(公告)日:2024-09-12
申请号:US18668578
申请日:2024-05-20
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC分类号: G06F16/27 , G06F16/182 , G06F16/245
CPC分类号: G06F16/273 , G06F16/1844 , G06F16/245
摘要: Techniques for database replication include a method performed by at least one hardware processor of a resource management node. The method includes detecting a request that a database instance of a database stored at a first network deployment is available at a second network deployment. Responsive to the request, the second network deployment is provisioned with a plurality of data objects. A first data object of the plurality of data objects includes a database shell. The database shell is reconfigured as the database instance of the database based on pushing data of the database into the database shell. Access to the database instance at the second network deployment is authorized based on at least a second data object of the plurality of data objects.
-
公开(公告)号:US20240273070A1
公开(公告)日:2024-08-15
申请号:US18652579
申请日:2024-05-01
申请人: SNOWFLAKE INC.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Vishnu Dutt Paladugu , Bowen Zhang
IPC分类号: G06F16/182 , G06F9/54 , G06F16/11 , G06F16/17
CPC分类号: G06F16/1844 , G06F9/546 , G06F16/128 , G06F16/1734 , G06F16/1827
摘要: Provided herein are systems and methods for replicating share objects to remote deployments. An example method includes creating a share object for a first deployment of a data sharing platform. The share object includes share object metadata that describes access privileges in the first deployment. The method also includes creating, in a second deployment of the data sharing platform, a replica of the share object. The replica determines access privileges in the second deployment. The method also includes receiving, at the first deployment, a refresh message from the second deployment. The method also includes, in response to receiving the refresh message, transmitting the share object metadata from the first deployment to the second deployment and updating, by a processing device, the replica based on the share object metadata.
-
公开(公告)号:US12050711B2
公开(公告)日:2024-07-30
申请号:US18378575
申请日:2023-10-10
申请人: Snowflake Inc.
发明人: Damien Carru , Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Subramanian Muralidhar , Bowen Zhang
CPC分类号: G06F21/6218 , G06F16/21 , G06F16/256 , G06F2221/2141
摘要: Embodiments of the present disclosure relate to sharing data using database roles. Database roles are generated within a database container of a provider account. Grants to a particular subset of the plurality of data objects of the database container may be assigned to each of the database roles, and each of the database roles are granted to a share object. The share object is mounted within a consumer account to generate an imported copy of each of the database roles. The imported copy of one or more of the database roles is granted to each of one or more account level roles of the consumer account. When a new object is added to a particular database role, it is immediately available for consumption by any account level roles to which the imported copy of the particular database role has been granted.
-
公开(公告)号:US20240232226A1
公开(公告)日:2024-07-11
申请号:US18617083
申请日:2024-03-26
申请人: Snowflake Inc.
IPC分类号: G06F16/28 , G06F9/50 , G06F16/2455 , H04L41/0896 , H04L41/5025 , H04L43/0817 , H04L67/1008 , H04L67/1097
CPC分类号: G06F16/283 , G06F9/5072 , G06F16/2455 , H04L41/0896 , H04L41/5025 , H04L67/1008 , H04L67/1097 , H04L43/0817
摘要: A method implementing a fault-tolerant data warehouse including allocating a plurality of processing units to a data warehouse, the processing units located in different availability zones, an availability zone comprising one or more data centers. The method further includes, as a result of monitoring a number of queries running at an input degree of parallelism on the plurality of processing units of the data warehouse, determining that the number of queries is serviceable by one fewer processing units. The method further includes routing a query from a first processing unit to a second processing unit within the data warehouse, the query having a common session identifier with another query previously provided to the second processing unit, the second processing unit determined to be caching a data segment associated with a cloud storage resource, usable by the query, and removing the first processing unit from the data warehouse.
-
公开(公告)号:US12032588B2
公开(公告)日:2024-07-09
申请号:US18160802
申请日:2023-01-27
申请人: SNOWFLAKE INC.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC分类号: G06F16/21 , G06F16/2455 , G06F16/25 , G06F21/62
CPC分类号: G06F16/254 , G06F16/21 , G06F16/2456 , G06F21/6218
摘要: A method includes creating, by a first provider, a first listing referencing first shared data and comprising first access controls, wherein access to the first shared data by a second provider is filtered based on the first access controls, creating, by the second provider, a second listing referencing second shared data and the first shared data filtered based on the first access controls, and adding the second listing to a catalog in a data exchange, the catalog comprising metadata describing the second shared data.
-
公开(公告)号:US20240168938A1
公开(公告)日:2024-05-23
申请号:US18427786
申请日:2024-01-30
申请人: Snowflake Inc.
IPC分类号: G06F16/23 , G06F9/46 , G06F16/18 , G06F16/245 , G06F16/27
CPC分类号: G06F16/2358 , G06F16/1865 , G06F16/2322 , G06F16/2365 , G06F16/245 , G06F16/278 , G06F9/466
摘要: A system includes one or more processors configured as a change tracking manager, and data storage containing instructions executable by the one or more processors. A table data component of the change tracking manager stores table data for a database in a plurality of partitions. A transaction data component of the change tracking manager generates a change tracking entry based on executing a transaction on the table data. The change tracking entry includes information on at least one modification made to a first table version storing the table data. A change tracking component of the change tracking manager generates a change tracking stream associated with the at least one modification. The change tracking component updates a second table version to include the change tracking stream. The second table version includes modified table data based on completing execution of the transaction on the table data in the first table version.
-
公开(公告)号:US11868369B2
公开(公告)日:2024-01-09
申请号:US17667268
申请日:2022-02-08
申请人: Snowflake Inc.
IPC分类号: G06F15/167 , G06F16/27 , G06F9/50 , G06F16/14 , G06F16/21 , G06F16/22 , G06F16/951 , G06F16/182 , G06F16/23 , G06F16/2455 , G06F16/2458 , G06F16/9535 , G06F16/2453 , H04L67/568 , G06F16/28 , G06F16/25 , A61F5/56 , G06F16/9538 , G06F9/48 , H04L67/1095 , H04L67/1097
CPC分类号: G06F16/273 , A61F5/566 , G06F9/4881 , G06F9/5016 , G06F9/5044 , G06F9/5083 , G06F9/5088 , G06F16/148 , G06F16/1827 , G06F16/211 , G06F16/221 , G06F16/2365 , G06F16/2456 , G06F16/2471 , G06F16/24532 , G06F16/24545 , G06F16/24552 , G06F16/254 , G06F16/27 , G06F16/283 , G06F16/951 , G06F16/9535 , G06F16/9538 , H04L67/1095 , H04L67/1097 , H04L67/568
摘要: Example resource management systems and methods are described. In one implementation, a resource manager is configured to manage data processing tasks associated with multiple data elements. An execution platform is coupled to the resource manager and includes multiple execution nodes configured to store data retrieved from multiple remote storage devices. Each execution node includes a cache and a processor, where the cache and processor are independent of the remote storage devices. A metadata manager is configured to access metadata associated with at least a portion of the multiple data elements.
-
公开(公告)号:US20230412647A1
公开(公告)日:2023-12-21
申请号:US18353445
申请日:2023-07-17
申请人: Snowflake Inc.
发明人: Damien Carru , Jeremy Yujui Chen , Timothy S. Conkling , Thierry Cruanes , Benoit Dageville , Unmesh Jagtap , William A. Pugh , Shrikant Ravindra Shanbhag , Xu Xu
IPC分类号: H04L9/40 , G06F16/955
CPC分类号: H04L63/20 , G06F16/955 , H04L63/102
摘要: A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.
-
-
-
-
-
-
-
-
-