Delivery Specialization: CDW Migration Best Practices

This course is meant to provide guidance on best practices for executing a successful migration from Cloud Data Warehouses (CDWs) - e.g. Amazon Redshift, Snowflake, and Synapse Analytics - to Databricks. It covers a wide range of migration processes starting from initial discovery all the way through to delivery.

Skill Level

Professional

Duration

10h

Prerequisites

Databricks Platform Proficiencies:

• Configure & optimize SQL Warehouses, Jobs & Workflows

• Unity Catalog security, lineage & Delta Sharing

• Lakeflow bundles & serverless compute workflows

Real-World Experience

• ≥ 6 months building Spark SQL / PySpark ETL pipelines

• Deploy & monitor pipelines with Auto Loader & Delta Live Tables

• Performance tuning via Spark UI & cluster selection

Broader Domain Knowledge

• Medallion architecture (Bronze → Gold) & Delta Lake optimizations

• Dimensional & 3NF modeling; governed data sharing

• Cost‑aware design for multi‑cloud federation

Outline

1. Course Introduction

2. Discovery and Assessment

• Why Migrate to Databricks?

• Conducting Discovery Workshops

• Architecture Assessment

3. Architecture Design and Planning

• Architecture Feature Mapping

4. Data Warehouse Migration

• Pre-Migration Considerations

• Schema Migration

• Data Migration

• Other Database Object Migration

• Governance & Security Migration

• Best Practices

5. Code and ETL Pipelines Migration

• Orchestration Migration

• Code Migration

6. BI and Analytics Tools Integration

• Downstream Tools and Cutovers

• BI & Analytics Integration Execution

7. Migration Validation

• DevSecOps

• Validation Phases and Methods

• Lakebridge

• Lakebridge: Installation

8. Course Summary & Next Steps

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Customer registration Partner registration

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Blended Learning

Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase

Purchase now

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

Data Warehousing Practitioner

Delivery Specialization: EDW Migration Best Practices

This course is meant to provide guidance on best practices for executing a successful migration from Enterprise Data Warehouses (EDWs) - e.g. Netezza, Teradata, Oracle, and Microsoft SQL Server - to Databricks. It covers a wide range of migration processes starting from initial discovery all the way through to delivery.

Note: Databricks Academy is transitioning from video lectures to a more streamlined PDF format with slides and notes for all self-paced courses. Please note that demo videos will still be available in their original format. We would love to hear your thoughts on this change, so please share your feedback through the course survey at the end. Thank you for being a part of our learning community!

Data Warehousing Practitioner

Get Started with Databricks for Data Warehousing

This course provides a comprehensive overview of Databricks’ modern approach to data warehousing, highlighting how a data lakehouse architecture combines the strengths of traditional data warehouses with the flexibility and scalability of the cloud. You’ll learn about the AI-driven features that enhance data transformation and analysis on the Databricks Data Intelligence Platform. Designed for data warehousing practitioners, this course provides you with the foundational information needed to begin building and managing high-performant, AI-powered data warehouses on Databricks.

Paid & Subscription

Lab

Onboarding

Platform Administrator

Get Started with Data Governance on Databricks

In this course, you will explore Unity Catalog and fine-grained access controls on Databricks with hands-on demos and a capstone lab. You will learn about table types, catalog and schema configuration, group-based access management, and access control migration strategies. The course includes demos on applying Fine-Grained Access Controls with Row Level Security and Column Masking, Attribute based access control, combining controls, migrating controls, and a lab for comprehensive governance implementation.

Paid & Subscription

Lab

Onboarding