-
公开(公告)号: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.
-
公开(公告)号:US20220300533A1
公开(公告)日:2022-09-22
申请号:US17662963
申请日:2022-05-11
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC分类号: G06F16/27 , G06F16/182
摘要: Techniques for database configurations for remote deployments include a method performed by a data platform executing instructions on at least one processor. The method includes provisioning by at least one hardware processor, a remote deployment of a data platform with a plurality of objects. The plurality of objects includes at least one task object associated with a primary deployment of the data platform. The method further includes detecting using the at least one task object of the plurality of objects, a request to replicate a database stored at the primary deployment of the data platform at the remote deployment. Responsive to the request, database data is pushed from the database stored at the primary deployment to at least a second object of the plurality of objects provisioned at the remote deployment.
-
公开(公告)号:US11347773B1
公开(公告)日:2022-05-31
申请号:US17490614
申请日:2021-09-30
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC分类号: G06F16/00 , G06F16/27 , G06F16/182
摘要: Disclosed herein are systems and methods for database replication to a remote deployment with automated fulfillment. In an embodiment, a data platform detects receipt of a database-replication request associated with a data consumer, requesting availability of a local instance of a primary-deployment database in a remote-deployment account of a data provider at a remote deployment of the data platform. The data platform responsively performs remote-deployment-activation operations including provisioning the remote-deployment account with a set of one or more replication-preparation objects associated with the primary-deployment database, and also including invoking at least one refresh command with respect to the set of one or more replication-preparation objects, which makes available to the data consumer a local instance of the primary-deployment database in the remote-deployment account of the data provider at the remote deployment of the data platform.
-
公开(公告)号:US11989206B2
公开(公告)日:2024-05-21
申请号:US17815375
申请日:2022-07-27
申请人: 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 using replication preparation objects include storing, by at least one hardware processor, at least one task object at a remote deployment of a data provider. A replication request originating from an account of a data consumer is detected at the remote deployment using the at least one task object. The replication request is associated with a database available at a primary deployment of the data provider. Responsive to the detecting of the replication request, a local instance of the database is generated at the remote deployment. The account of the data consumer at the remote deployment is configured to access the local instance of the database.
-
公开(公告)号:US20230316348A1
公开(公告)日:2023-10-05
申请号:US17710598
申请日:2022-03-31
申请人: Snowflake Inc.
发明人: Benoit Dageville , Sameer Deshpande , Eric Dorf , Subramanian Muralidhar , Chao Ren , Dangfu Wang
CPC分类号: G06Q30/04 , G06Q20/145 , G06F9/547 , G06F16/256
摘要: Embodiments of the present disclosure describe techniques for monitoring usage of data listings and pricing data listings based thereon. Metadata comprising a pricing plan may be added to a data listing to generate a monetized data listing. The monetized data listing may be imported to the consumer account. The usage data of the monetized data listing and listing data of the monetized data listing may be exported to a data warehousing and analysis module. A usage level for a set of jobs processed using the monetized data listing during a current incremental interval of a current billing interval may be calculated and combined with a usage level of all previous incremental intervals of the current billing interval to generate a cumulative usage record. An invoice for the billing interval may be generated based on the cumulative usage record.
-
公开(公告)号:US20230237069A1
公开(公告)日:2023-07-27
申请号:US18128130
申请日:2023-03-29
申请人: 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/245 , G06F16/1844
摘要: Techniques for database replication for a remote deployment include a method performed by a data platform executing instructions on at least one hardware processor. The method includes detecting receipt of a database replication request associated with a data consumer. The database replication request is requesting availability of an instance of a primary deployment database at a remote deployment of a data platform. In response to detecting the receipt of the database replication request, an account of a data provider at the remote deployment of the data platform is provisioned with a set of replication-preparation objects associated with the primary deployment database. A database refresh operation is invoked, causing database data be pushed from the primary deployment database to a database shell in the account of the data provider at the remote deployment, to create the instance of the primary deployment database.
-
公开(公告)号:US11163798B1
公开(公告)日:2021-11-02
申请号:US17302397
申请日:2021-04-30
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC分类号: G06F16/00 , G06F16/27 , G06F16/182
摘要: Disclosed herein are systems and methods for database replication to a remote deployment with automated fulfillment. In an embodiment, a data platform detects receipt of a database-replication request associated with a data consumer, requesting availability of a local instance of a primary-deployment database in a remote-deployment account of a data provider at a remote deployment of the data platform. The data platform responsively performs remote-deployment-activation operations including provisioning the remote-deployment account with a set of one or more replication-preparation objects associated with the primary-deployment database, and also including invoking at least one refresh command with respect to the set of one or more replication-preparation objects, which makes available to the data consumer a local instance of the primary-deployment database in the remote-deployment account of the data provider at the remote deployment of the data platform.
-
公开(公告)号:US12032595B2
公开(公告)日:2024-07-09
申请号:US18128130
申请日:2023-03-29
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC分类号: G06F16/00 , G06F16/182 , G06F16/245 , G06F16/27
CPC分类号: G06F16/273 , G06F16/1844 , G06F16/245
摘要: Techniques for database replication for a remote deployment include a method performed by a data platform executing instructions on at least one hardware processor. The method includes detecting receipt of a database replication request associated with a data consumer. The database replication request is requesting availability of an instance of a primary deployment database at a remote deployment of a data platform. In response to detecting the receipt of the database replication request, an account of a data provider at the remote deployment of the data platform is provisioned with a set of replication-preparation objects associated with the primary deployment database. A database refresh operation is invoked, causing database data be pushed from the primary deployment database to a database shell in the account of the data provider at the remote deployment, to create the instance of the primary deployment database.
-
公开(公告)号:US11163797B1
公开(公告)日:2021-11-02
申请号:US17302396
申请日:2021-04-30
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Sameer Deshpande , Subramanian Muralidhar , Di Wu
IPC分类号: G06F16/27
摘要: Disclosed herein are systems and methods for database replication to a remote deployment with automated fulfillment. In an embodiment, a data platform provisions a remote-deployment account of a data provider at a remote deployment of the data platform with a set of one or more replication-preparation objects associated with a primary-deployment database that is resident in a primary-deployment account of the data provider at a primary deployment of the data platform. After the provisioning, the data platform detects receipt of a database-replication request associated with a data consumer, requesting availability of a local instance of the primary-deployment database in the remote-deployment account of the data provider. The data platform responsively performs one or more remote-deployment-activation operations, which makes available to the data consumer a local instance of the primary-deployment database in the remote-deployment account of the data provider at the remote deployment of the data platform.
-
公开(公告)号:US11869051B2
公开(公告)日:2024-01-09
申请号:US17710598
申请日:2022-03-31
申请人: Snowflake Inc.
发明人: Benoit Dageville , Sameer Deshpande , Eric Dorf , Subramanian Muralidhar , Chao Ren , Dangfu Wang
CPC分类号: G06Q30/04 , G06F9/547 , G06F16/256 , G06Q20/145
摘要: Embodiments of the present disclosure describe techniques for monitoring usage of data listings and pricing data listings based thereon. Metadata comprising a pricing plan may be added to a data listing to generate a monetized data listing. The monetized data listing may be imported to the consumer account. The usage data of the monetized data listing and listing data of the monetized data listing may be exported to a data warehousing and analysis module. A usage level for a set of jobs processed using the monetized data listing during a current incremental interval of a current billing interval may be calculated and combined with a usage level of all previous incremental intervals of the current billing interval to generate a cumulative usage record. An invoice for the billing interval may be generated based on the cumulative usage record.
-
-
-
-
-
-
-
-
-