Load data into a Microsoft Fabric data warehouse

  • Module
  • 8 Units
Beginner
Data Analyst
Data Engineer
Microsoft Fabric

Learn how to load data into a Fabric warehouse using data pipelines, T-SQL, and Dataflow Gen2, and explore strategies for full loads, incremental loads, and slowly changing dimensions.

Learning objectives

In this module, you learn how to:

  • Identify when to use full loads versus incremental loads for a data warehouse.
  • Describe how Copy jobs in data pipelines ingest data into a warehouse.
  • Explain how T-SQL COPY statements, CTAS, and INSERT...SELECT load data into a warehouse.
  • Describe how Dataflow Gen2 imports and transforms data before loading.

Prerequisites

Before starting this module, you should be familiar with the basic concepts of a data warehouse.

Start