Home › Migration use cases

Real-world migration use cases

On-premise to Snowflake migration, explained use case by use case.

Each use case is a complete blueprint from a real-style engagement: the business situation, every option with pros and cons, what to recommend and avoid, how the Snowflake account is designed and secured, how the data is validated, the plan, the risks, and draw.io architecture diagrams you can open and edit.

What every use case covers

Options comparedHistorical load and delta sync choices, with clear pros, cons and fit.
Snowflake designDatabases and schemas, accounts and environments, warehouses and cost.
Security & accessRole-based access, SSO, masking, row policies and audit.
DeliveryValidation, plan and timeline, risks, open decisions and diagrams.

Use cases

Available SQLSQL Server → Snowflake

Hundreds of on-premise SQL Server databases (3–4 TB) copied into a brand-new Snowflake platform while the source stays live.

  • Historical load: Python → Parquet → PUT → COPY INTO
  • Delta sync: Change Tracking + Airflow → MERGE
  • Accounts, RBAC, security, validation, 8–14 week plan
  • 3 draw.io diagrams included
Open the blueprint
Coming soon ORAOracle → Snowflake

Oracle Database to Snowflake: PL/SQL, partitions, GoldenGate CDC and data type mapping.

Coming soon TDTeradata → Snowflake

Teradata to Snowflake: BTEQ, FastExport, macros, workload sizing and SQL conversion.

Coming soon NZNetezza → Snowflake

IBM Netezza / PureData to Snowflake: nzsql, distribution keys and cut-over planning.

Coming soon ETLInformatica / DataStage → Snowflake

Legacy ETL to ELT: re-platforming mappings and jobs to Snowflake SQL, dbt and Airflow.

Coming soon HDPHadoop / Hive → Snowflake

Hadoop and Hive data lakes to Snowflake and Iceberg tables.

Planning a migration, or preparing for migration interviews?

Talk to Jitendra about your source system, volumes and timelines, or learn to deliver projects like these in the Cloud Data Engineer program.

Book a free call