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

Get Started with Databricks for Generative AI - Mandarin Chinese

本课程提供对 Mosaic AI 平台的实用入门介绍，重点讲解用于构建和部署生成式 AI 系统的核心组件与功能。学员将了解 Databricks 如何助力开发可扩展的生成式 AI 解决方案，并探索 Mosaic AI 的相关工具，例如 Vector Search、Agent Framework，以及 MLflow 用于模型跟踪与记录的生成式 AI 功能。本课程包含动手实践，内容涵盖构建并评估检索增强生成 (RAG) 管道、部署生成式 AI 智能体，以及利用评估框架优化性能。完成本课程后，学员将掌握使用 Mosaic AI 设计、部署和监控常见生成式 AI 应用所需的技能。

Languages Available: English | 日本語 | Português BR | 한국어

Paid & Subscription

Lab

Onboarding

Catalog Management and Data Organization

In this course, you will learn how to design, implement, and govern catalog structures and large-scale data organization on the Databricks Data Intelligence Platform. It offers a comprehensive view of Unity Catalog as the centralized governance layer for an enterprise lakehouse. Divided into five modules, it begins by placing Unity Catalog within the cloud deployment model — covering the Account Console, metastore creation, and the administrator role hierarchy. You will then translate organizational topology (business units, regions, and dev/QA/prod environments) into a scalable catalog and schema design using naming conventions, ownership patterns, and MANAGE delegation. The course then covers secure storage integration with storage credentials, external locations, the managed-storage hierarchy, managed versus external tables, and UC Volumes for non-tabular data. Next, you will apply access patterns and isolation strategies — the three-level GRANT chain, workspace-catalog binding, and schema-level Attribute-Based Access Control (ABAC) policies — to enforce fine-grained data protection at scale. Finally, the course closes with best practices for catalog design, automation, least-privilege permissions, and group-based access management.

Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Data Modeling Strategies

This course walks practitioners through the full spectrum of data modelling approaches on the Databricks Data Intelligence Platform - from classical data warehouse techniques (Inmon, Kimball, Data Vault 2.0), through Feature Store-driven ML use cases, to productising data via Data Products on Unity Catalog.

Each modelling approach is introduced with a lecture, then reinforced with a hands-on demo against a shared dataset (TPC-H samples). The course finishes with a comprehensive end-to-end lab that exercises ERM, dimensional modelling, Data Vault 2.0, and the Feature Store in a single integrated workflow.

Note:

1. The course includes practice labs that the learners should perform after going through the entire course.

2. For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Languages Available: English | 日本語 | Português BR | 한국어

Paid & Subscription

Lab

Associate