SQL Migrate
SQL Migrate is a custom Snowflake Native Application that faciliates
moving Schemas, Tables, Columns from typically on premisis databases
to Snowflake.
SQL Migrate is not an ETL tool. SQL Migrate is used to create a duplicate of the schema. It migrates tables, columns, primary keys, foreign keys, column types, defaults, null/not null and identity to Snowflake.
Yes, most of these are for documentation purposes and are not enforced by Snowflake. However, having the attributes correct in your Snowflake database helps all of the downstream teams know how your data is defined.
SQL Migrate is not an ETL tool. SQL Migrate is used to create a duplicate of the schema. It migrates tables, columns, primary keys, foreign keys, column types, defaults, null/not null and identity to Snowflake.
Yes, most of these are for documentation purposes and are not enforced by Snowflake. However, having the attributes correct in your Snowflake database helps all of the downstream teams know how your data is defined.