Go back
GlobalMart’s Data Migration from SQL Server to Snowflake
9 Scenarios
4 Hours 30 Minutes
Intermediate
Industry
e-commerce
Skills
problem-understanding
data-understanding
data-storage
data-wrangling
batch-etl
stream-etl
data-quality
access-control-security
performance-tuning
Tools
snowflake
Learning Objectives
Perform schema discovery and data profiling on SQL Server databases.
Design and Implement Snowflake Data Warehouse Schema
Develop Data Extraction Strategies for Full and Incremental Loads
Set up and manage cloud storage buckets for staging data files.
Implement role-based access controls and data masking policies.
Overview
Prerequisites
- Solid understanding of SQL for writing complex queries, transformations, and validation scripts.
- Experience with Snowflake data warehouse concepts and schema design
- Familiarity with cloud storage platforms such as AWS S3, Azure Blob Storage, or GCP Storage.
- Knowledge of data ingestion techniques including bulk loading and streaming ingestion in Snowflake