US 12,032,595 B2
Database replication for a remote deployment
Pui Kei Johnston Chu, Richmond Hill (CA); Benoit Dageville, San Mateo, CA (US); Shreyas Narendra Desai, Bellevue, WA (US); Sameer Deshpande, Mountain View, CA (US); Subramanian Muralidhar, Mercer Island, WA (US); and Di Wu, Newark, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Mar. 29, 2023, as Appl. No. 18/128,130.
Application 18/128,130 is a continuation of application No. 17/662,963, filed on May 11, 2022, granted, now 11,645,306.
Application 17/662,963 is a continuation of application No. 17/490,614, filed on Sep. 30, 2021, granted, now 11,347,773.
Application 17/490,614 is a continuation of application No. 17/302,397, filed on Apr. 30, 2021, granted, now 11,163,798.
Claims priority of provisional application 63/200,668, filed on Mar. 21, 2021.
Prior Publication US 2023/0237069 A1, Jul. 27, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/182 (2019.01); G06F 16/245 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/273 (2019.01) [G06F 16/1844 (2019.01); G06F 16/245 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A method performed by a data platform executing instructions on at least one hardware processor, the method comprising:
detecting receipt of a database replication request associated with a data consumer, the database replication request requesting availability of an instance of a primary deployment database at a remote deployment of a data platform; and
in response to detecting the receipt of the database replication request:
provisioning an account of a data provider at the remote deployment of the data platform with a set of replication-preparation objects associated with the primary deployment database;
invoking a database refresh operation causing database data to 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; and
configuring access to the instance of the primary deployment database based on a share shell of the account of the data provider at the remote deployment.