Visão Geral

O Curso Teradata to Snowflake Migration Guide é voltado para profissionais de dados que desejam planejar e executar a migração de ambientes Teradata para Snowflake de forma segura, eficiente e otimizada.
O treinamento cobre todas as etapas da migração, incluindo análise de arquitetura, modelagem de dados, transformação de SQL, movimentação de dados, ajuste de performance e integração com ferramentas externas.

O curso combina teoria, demonstrações práticas e laboratórios hands-on, garantindo que o participante saia apto a planejar e executar migrações reais, minimizando riscos e maximizando performance e custo-benefício.

Objetivo

Após realizar o curso Teradata to Snowflake Migration Guide, você será capaz de:

• Compreender diferenças e semelhanças entre Teradata e Snowflake
• Planejar e executar migrações de data warehouses corporativos
• Transformar SQL Teradata para Snowflake compatível
• Aplicar técnicas de performance tuning e otimização de custos
• Integrar pipelines migrados com ferramentas de BI, ETL e análise

Publico Alvo

• Engenheiros de Dados e DBAs que trabalham com Teradata e Snowflake
• Arquitetos de Dados que planejam migrações de data warehouses
• Desenvolvedores e profissionais de BI que desejam entender diferenças e compatibilidades entre Teradata e Snowflake
• Gerentes e líderes de projetos de migração de dados corporativos

Pre-Requisitos

• Experiência com Teradata SQL e ambientes de Data Warehouse
• Conhecimento básico de Snowflake e SQL padrão
• Noções de ETL, modelagem de dados e nuvem (AWS, Azure ou GCP)

Materiais

Conteúdo Programatico

Module 1: Introduction and Migration Overview

1. Overview of Teradata and Snowflake architectures
2. Key differences: storage, compute, and services layer
3. Benefits and challenges of migrating to Snowflake
4. Migration planning and best practices
5. Data security, compliance, and governance considerations

Module 2: Teradata Environment Assessment

1. Inventory of Teradata objects (tables, views, indexes, macros, procedures)
2. Data profiling and quality assessment
3. Identifying high-volume and high-complexity workloads
4. Estimating storage and compute requirements in Snowflake
5. Migration risk assessment

Module 3: Snowflake Fundamentals for Migration

1. Snowflake architecture, virtual warehouses, and databases
2. Storage optimization and micro-partitioning
3. Snowflake SQL differences from Teradata SQL
4. Data loading options: bulk load, Snowpipe, external stages
5. Security, roles, and access control

Module 4: SQL and Script Conversion

1. Differences between Teradata SQL and Snowflake SQL
2. Converting joins, aggregations, window functions, and analytical queries
3. Stored procedure and UDF migration
4. Handling semi-structured data (VARIANT, JSON, Parquet)
5. Automation tools for SQL conversion

Module 5: Data Migration Strategies

1. Extract-Transform-Load (ETL) vs Extract-Load-Transform (ELT) approaches
2. Bulk data movement from Teradata to Snowflake
3. Incremental and real-time data migration strategies
4. Using cloud storage as staging (S3, Azure Blob, GCS)
5. Data validation and reconciliation after migration

Module 6: Performance Tuning and Optimization

1. Warehouse sizing and auto-scaling in Snowflake
2. Query optimization techniques post-migration
3. Caching and clustering keys for performance improvement
4. Optimizing ETL and transformation pipelines
5. Monitoring job performance and costs

Module 7: Integration and Ecosystem

1. Connecting Snowflake with BI tools (Power BI, Tableau, Looker)
2. Integration with ETL tools (Informatica, Matillion, Azure Data Factory)
3. Streaming data ingestion with Snowpipe and Kafka
4. Working with Snowpark and dbt for transformations
5. External table access and data sharing

Module 8: Testing, Validation, and Cutover

1. Unit testing and regression testing for migrated objects
2. Data validation strategies (row counts, checksums, sampling)
3. Cutover planning and rollback strategy
4. Monitoring for errors and performance after migration
5. Documentation and handover to production team

Module 9: Hands-on Labs

1. Assessing a Teradata environment and identifying migration scope
2. Converting SQL queries and stored procedures to Snowflake
3. Loading sample datasets into Snowflake
4. Testing and validating migrated data
5. Performance tuning and optimization exercises

Module 10: Best Practices and Lessons Learned

1. Key considerations for successful migration projects
2. Common pitfalls and how to avoid them
3. Enterprise data governance and compliance
4. Cost management strategies in Snowflake
5. Real-world case studies of Teradata to Snowflake migrations