SQL Migrate
SQL Migrate is a custom Snowflake Native Application that facilities
moving Schemas, Tables, Columns from typically on premises 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.