Data Management Ecosystem for Databases

A method comprising:

• receiving, from a user device, a request to migrate one or more data objects from a sandbox to a production environment of at least one of a plurality of data warehouses that are provided as a service in a cloud computing environment, wherein computing resources are dynamically allocated to the plurality of data warehouses;
• scanning a plurality of queries in the sandbox to determine the one or more data objects to be migrated to the production environment;
• provisioning access to the one or more data objects in the production environment;
• determining lineage information for each of the one or more data objects, wherein the lineage information comprises an origin of each of the one or more data objects, and a frequency with which each of the one or more data objects has been accessed;
• prior to an execution of a migration plan, updating a database catalog of the at least one of the plurality of data warehouses with the lineage information;
• identifying sensitive data contained within the one or more data objects;
• generating a tokenization for at least a portion of the sensitive data, wherein the tokenization replaces the portion of the sensitive data with a non-sensitive token without altering a type or length of the portion of the sensitive data;
• generating, based on the lineage information in the database catalog and the tokenization, a migration plan for the migration path from the sandbox to the production environment of the at least one of the plurality of data warehouses;
• validating the migration plan based on data control criteria in the production environment;
• and
• after the validation, causing the at least one of the plurality of data warehouses to execute the migration plan in the production environment.

One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause a computing device to:

• receive, from a user device, a request to migrate one or more data objects from a sandbox to a production environment of at least one of a plurality of data warehouses that are provided as a service in a cloud computing environment, wherein computing resources are dynamically allocated to the plurality of data warehouses;
• scan a plurality of queries in the sandbox to determine the one or more data objects to be migrated to the production environment;
• provision access to the one or more data objects in the production environment;
• determine lineage information indicating for each of the one or more data objects, wherein the lineage information comprises an origin of each of the one or more data objects, and a frequency with which each of the one or more data objects has been accessed;
• prior to an execution of a migration plan, update a database catalog of the at least one of the plurality of data warehouses with the lineage information;
• identifying sensitive data contained within the one or more data objects;
• generate a tokenization for at least a portion of the sensitive data, wherein the tokenization replaces the portion of the sensitive data with a non-sensitive token without altering a type or length of the portion of the sensitive data;
• generate, based on the lineage information in the database catalog and the tokenization, the migration plan for a migration path from the sandbox to the production environment of the at least one of the plurality of data warehouses;
• validate the migration plan based on data control criteria in the production environment;
• and
• after the validation, cause the at least one of the plurality of data warehouses to execute the migration plan in the production environment.