cyberhiker
Reputation: 71
Best Practices / Lessons Learned for Migrating to Snowflake from SQL Server or DB2
Does anyone have a list of Best Practices or Lessons Learned for migrating to Snowflake from SQL Server or DB2?
We're learning as we go but are discovering that some things don't work the same (we expected some learnings). Examples: Primary Key Constraints not being enforced; CAST of varchar to a shorter field is a hard error vs a warning so ETL process abends.
I have not found documentation (other than generic recommendations on planning and some good recommendations around data loads) but limited info on ETL practices.
Upvotes: 0
Views: 889
Answers (1)
Related Questions
- MSSQL to Snowflake Data Type Mapping
- Data migration for .SQB files to Snowflake
- When Migrating from SQL Server to Snowflake how do we migrate stored procedures
- Migrating SQlserver NVARCHAR(MAX) --> Snowflake
- For SSAS Cube lift and shift approach, does migrating to snowflake, will it be an advantage for better performance and how
- Replicate SQL Server data to Snowflake
- Transformation in Snowflake or Azure data Factory?
- Snowflake Cloud data warehouse - Database best practice limitations
- Migrating stored procedures from Teradata BTEQ to Snowflake
- How to migrate data from one snowflake instance to another, best performance option?