Methods and systems for generating recommendations in cloud-based data warehousing system

A first computing device associated with a first data manager account hosted in a first cloud region of a cloud-based data warehouse 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 a request to collect data from one or more client accounts associated with a first client and hosted by the cloud-based data warehouse system;
• send, to a second computing device associated with a first client account, first instructions to share, with a second data manager account hosted in a second cloud region of the cloud-based data warehouse system, data from the first client account;
• send, to a third computing device associated with the second data manager account, second instructions to replicate the shared data to the first data manager account, upon receipt of an indication that the shared data is accessible;
• receive an indication that the shared data has been replicated;
• store, based on the indication that the shared data has been replicated, the shared data in a database associated with the first manager account;
• retrieve configuration information associated with a plurality of recommendation algorithms associated with the first client, wherein the configuration information indicates an execution frequency for each of the plurality of recommendation algorithms;
• retrieve information indicating a last execution date for each of the plurality of recommendation algorithms;
• determine, based on the configuration information, the execution frequency of each of the plurality of recommendation algorithms, and the last execution date for each of the plurality of recommendation algorithms, that a first recommendation algorithm of the plurality of recommendation algorithms is scheduled for execution;
• cause, using the stored shared data, execution of the first recommendation algorithm;
• receive, based on execution of first recommendation algorithm, at least one recommendation associated with a first data warehouse associated with the first client;
• and
• output the at least one recommendation.

A cloud data management system comprising:

• a first computing device associated with a first data manager account hosted in a first cloud region of a cloud-based data warehouse system;
• a second computing device associated with a first client account;
• a third computing device associated with a second data manager account;
• wherein the first computing device is configured to:
• receive a request to collect data from one or more client accounts associated with a first client and hosted by the cloud-based data warehouse system;
• send, to the second computing device, first instructions for the second computing device to share, with the second data manager account hosted in a second cloud region of the cloud-based data warehouse system, data from the first client account;
• send, to the third computing device, second instructions for the third computing device to replicate the shared data to the first data manager account, upon receipt of an indication that the shared data is accessible;
• receive an indication that the shared data has been replicated;
• store, based on the indication that the shared data has been replicated, the shared data in a database associated with the first manager account;
• retrieve configuration information associated with a plurality of recommendation algorithms associated with the first client, wherein the configuration information indicates an execution frequency for each of the plurality of recommendation algorithms;
• retrieve information indicating a last execution date for each of the plurality of recommendation algorithms;
• determine, based on the configuration information, the execution frequency of each of the plurality of recommendation algorithms, and the last execution date for each of the plurality of recommendation algorithms, that a first recommendation algorithm of the plurality of recommendation algorithms is scheduled for execution;
• cause, using the stored shared data, execution of the first recommendation algorithm;
• receive, based on execution of first recommendation algorithm, at least one recommendation associated with a first data warehouse associated with the first client;
• and
• output the at least one recommendation.