Snowflake Data Migration Checklist

Are you preparing to move data to a Snowflake data warehouse? Creating a well-thought out plan before your big move is essential. It is important to establish a timeline, budget, team roles and goals before you launch into a big migration.

To help ensure your migration is a success, we’ve created a Snowflake migration checklist that covers many of the little details we sometimes forget when caught up in a big move.

Snowflake Migration Checklist

Document the existing solution

  • List databases and data objects that need to be migrated
  • Define known data quality issues to be addressed
  • List processes and tools that populate and pull data from the existing solution
  • List security roles, users and permissions
  • List Snowflake accounts that exist or need to be created
  • Establish frequency of security provision processes
  • Document the existing solution into an “as-is” architecture diagram

Determine a migration approach

  • List processes to migrate as is
  • List processes that need re-engineering
  • List processes that need to be fixed
  • Draft migration deliverables
  • Create desired architecture diagram

Capture the development and deployment process

  • List tools that will be introduced with the migration
  • Validate function and performance of snowflake connectors
  • List tools that will be deprecated after the migration
  • List development environments needed for the migration
  • List deployment processes used for the migration

Prioritize datasets for migration

  • List data sets to migrate first (prioritize list)
  • Create method for identifying process dependencies for data sets
  • Document process dependencies for data sets

Determine a testing approach

  • Prepare to test migration of legacy data, loading from data sources, and performance
  • Identify testing methods and success criteria
  • Prepare for anticipated exceptions caused by process fixes
  • Identify testing tools

Plan to implement security

  • Identify processes and tools to implement security
  • Determine if revisions need to be made before migrating roles, users, and permissions

Identify the migration team

  • Create list of migration team members and roles with contact info

Define the migration deadlines and budget

  • List business expectations for the migration deadline
  • Document budget allocated for the migration project

Determine the migration outcomes

  • List high-level desired outcomes and assumptions at the completion of the migration
  • Document plan for communicating the migration project wins to stakeholders
By |2020-04-27T15:38:11-05:00January 27th, 2020|Blog|Comments Off on Snowflake Data Migration Checklist

About the Author:

Wendi O'Neill is the Practice Manager, Data & Analytics Solutions for Sirius Computer Solutions.