US 11,704,338 B1
Replication of share across deployments in database system
Pui Kei Johnston Chu, Richmond Hill (CA); Benoit Dageville, San Mateo, CA (US); Shreyas Narendra Desai, Bellevue, WA (US); Nithin Mahesh, Kirkland, WA (US); Subramanian Muralidhar, Mercer Island, WA (US); Vishnu Dutt Paladugu, Seattle, WA (US); Sahaj Saini, Seattle, WA (US); Chieh-Sheng Wang, San Mateo, CA (US); and Di Wu, Newark, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Feb. 28, 2022, as Appl. No. 17/652,721.
Int. Cl. G06F 16/30 (2019.01); G06F 16/27 (2019.01); G06F 16/25 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 16/213 (2019.01); G06F 16/256 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A data platform 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:
receiving a request by a first account to add a second account to a source share associated with the first account, the source share being configured to grant one or more accounts access to a set of database objects associated with the first account, the first account being on a source deployment of the data platform;
determining, based on the request, whether the second account is on the source deployment; and
in response to determining that the second account is not on the source deployment, replicating the source share on a target deployment of the data platform as a replicated share, the second account being on the target deployment, the replicating of the source share on the target deployment as the replicated share comprising:
accessing, on the source deployment, share data defining the source share;
determining, based on the share data, a set of dependencies that identify one or more database objects on the source deployment from which at least one database object of the set of database objects depends;
generating, on the source deployment, a replication group configured to replicate the source share on the target deployment as the replicated share, the replication group being configured with a refresh schedule, the refresh schedule enabling a change to a definition of the share dta on the source deployment to be applied to a definition of the replicated share on the target deployment; and
replicating, based on the replication group, the one or more database objects, of the source deployment, into a hidden namespace on the target deployment, the hidden namespace being associated with the first account on the target deployment.