US 11,989,206 B2
Automated database replication using replication preparation objects
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 Jul. 27, 2022, as Appl. No. 17/815,375.
Application 17/815,375 is a continuation of application No. 17/490,543, filed on Sep. 30, 2021, granted, now 11,436,255.
Application 17/490,543 is a continuation of application No. 17/302,396, filed on Apr. 30, 2021, granted, now 11,163,797.
Claims priority of provisional application 63/200,668, filed on Mar. 21, 2021.
Prior Publication US 2022/0358141 A1, Nov. 10, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/27 (2019.01); G06F 16/182 (2019.01); G06F 16/245 (2019.01)
CPC G06F 16/273 (2019.01) [G06F 16/1844 (2019.01); G06F 16/245 (2019.01)] 27 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
storing at least one task object at a remote deployment of a data provider;
detecting, using the at least one task object, a replication request originating from an account of a data consumer at the remote deployment, the replication request associated with a database available at a primary deployment of the data provider;
responsive to the detecting of the replication request, generating a local instance of the database at the remote deployment, the generating of the local instance based on invoking a database refresh operation and pushing database data of the database available at the primary deployment to a database shell at the remote deployment in response to the database refresh operation, the pushing causing modifying of the database shell from an empty shell without the database data into a remote deployment database shell configured as the local instance of the database, and the remote deployment database shell including the database data of the primary deployment based on completion of the pushing; and
configuring the account of the data consumer at the remote deployment to access the local instance of the database.