Methods of orchestrated data sharing across cloud regions and cloud platforms of cloud-based data warehousing systems

A first computing device associated with a cloud data management system, wherein the first computing device comprises:

• one or more processors;
• and
• memory storing instructions that, when executed by the one or more processors, cause the first computing device to:
• receive, from a first client account hosted by a first cloud-based data warehouse provider on a first cloud region, a request to share data with a second client account hosted by a second cloud-based data warehouse provider on a second cloud region;
• identify:
• a first data manager account hosted by the first cloud-based data warehouse provider on the first cloud region, and
• a second data manager account hosted by the second cloud-based data warehouse provider on the second cloud region;
• send, to a second computing device associated with the first client account, first instructions configured to cause the second computing device to share the data with the first data manager account;
• send, to a third computing device associated with the first data manager account, second instructions configured to cause the third computing device to:
• create a first data warehouse comprising at least one database for receiving shared data;
• upon receipt of the data shared from the first client account, persist the data shared from the first client account;
• replicate, to the second data manager account, the persisted data shared from the first client account;
• and
• drop the first data warehouse after replication of the persisted data shared from the first client account;
• and
• send, to a fourth computing device associated with the second data manager account, third instructions configured to cause the fourth computing device to, upon receipt of the replicated persisted data shared from the first client account, share the replicated persisted data shared from the first client account with the second client account.

A cloud data management system comprising:

• a first computing device associated with the cloud data management system;
• a second computing device associated with a first client account hosted by a first cloud-based data warehouse provider on a first cloud region;
• a third computing device associated with a first data manager account hosted by the first cloud-based data warehouse provider on the first cloud region;
• and
• a fourth computing device associated with a second data manager account hosted by a second cloud-based data warehouse provider on a second cloud region,
• wherein the first computing device is configured to:
• receive, from the first client account, a request to share data with a second client account hosted by the second cloud-based data warehouse provider on the second cloud region;
• identify the first data manager account and the second data manager account;
• send, to the second computing device, first instructions configured to cause the second computing device to share the data with the first data manager account;
• send, to the third computing device, second instructions configured to cause the third computing device to:
• create a first data warehouse comprising at least one database for receiving shared data;
• upon receipt of the data shared from the first client account, persist the data shared from the first client account;
• replicate, to the second data manager account, the persisted data shared from the first client account;
• and
• drop the first data warehouse after replication of the persisted data shared from the first client account;
• and
• send, to the fourth computing device, third instructions configured to cause the fourth computing device to, upon receipt of the replicated persisted data shared from the first client account, share the replicated persisted data shared from the first client account with the second client account.