Smart data transition to cloud

A method for migrating data from a source data warehouse to a cloud environment, the method including:

• storing data type connection information;
• predicting a location in the cloud environment based on the migrating data;
• predicting query performance of the cloud environment and classifying tables in the source data warehouse based on query usage, wherein the location recommender predicts the location based on a table accessed by a referential key and wherein the query performance is determined prior to migration to a target data warehouse based on a source database query execution time;
• providing data values based on historical data of past migration of the cloud, wherein the historical data is to train models for examining the data, executing queries, and responding to the queries, the models being generated based on data and metadata corresponding to the tables;
• identifying incorrect and sensitive data;
• obfuscating the incorrect and the sensitive data;
• and
• loading the migrating data on to the cloud environment.

A non-transitory Computer Readable Medium (CRM) including machine instructions and executable by a processor to migrate data from a source data warehouse to a cloud environment, wherein the instructions are to:

• store data type connection information
• predict a location in the cloud environment based on the migrating data;
• predict query performance of the cloud environment and classify tables in the source data warehouse based on query usage, wherein the location recommender predicts the location based on a table accessed by a referential key and wherein the query performance is determined prior to migration to a target data warehouse based on a source database query execution time;
• provide data values based on historical data of past migrations, wherein the historical data is to train models for examining the data, executing queries, and responding to the queries, the models being generated based on data and metadata corresponding to the tables;
• identify incorrect and sensitive data;
• obfuscate the incorrect and the sensitive data;
• and
• load the migrating data on the cloud environment.