10 Tips for Migrating from SAS Viya to Snowflake + dbt
TLDR: In this blog, we’ll share key insights from our recent project migrating a sports sector client from SAS Viya to Snowflake and dbt, focusing on practical tips to make your migration smoother. • Snowflake and dbt offer a powerful combination of modern analytics due to their support for version control for SQL code, automated testing, and documentation. • We discuss practical tips such as using the dbt-audit-helper package for comparing migrated tables, the challenges of lift-and-shift vs remodeling, and the intricacies of incremental flows. A bit of background A client of ours in the sports sector had been relying on SAS Viya as their primary analytics platform for several years. The platform housed more than 50 analytical flows that had been built up over multiple years, representing significant business logic and institutional knowledge. These flows were important for the organization’s decision-making processes and downstream reporting. ...