Data warehousing documentation in Microsoft Fabric

Learn more about Synapse Data Warehouse in Microsoft Fabric

Data warehousing

Overview

• Overview

Get started with Data Warehouse

Tutorial

• End to End tutorials
• Data warehouse tutorial
• Create a Warehouse quickstart
• Migrate Azure Synapse Analytics dedicated SQL pools to Fabric Warehouse

Get started with SQL analytics endpoint

Get Started

• What is a Lakehouse?
• Better together - the lakehouse and warehouse
• Create a lakehouse with OneLake
• Default Power BI semantic models
• Load data into the Lakehouse
• How to copy data using Copy activity in Data pipeline
• How to move data into Lakehouse via Copy assistant

Security

How-To Guide

• Data warehousing security
• Connectivity
• Microsoft Entra ID authentication
• Workspace roles
• SQL granular permissions
• Row-level security
• Column-level security
• Share your Warehouse

Ingest data

How-To Guide

• Ingest data guide
• Ingest data using pipelines
• Ingest data using TSQL
• Ingest data using Copy

Concept

• Database Mirroring in Fabric
• Mirroring Azure SQL Database
• Mirroring Azure Cosmos DB
• Mirroring Snowflake

Design and Develop

Concept

• Semantic models
• Model data in the default Power BI semantic model
• Define relationships in data models
• Reports in the Power BI service

Query

Concept

• Query using the SQL Query editor
• Query with T-SQL
• Query using visual query editor
• View data in the Data preview

Manage

How-To Guide

• Statistics
• Query insights
• Caching
• Troubleshoot

Monitor

How-To Guide

• Capacity Metrics app
• Monitor using DMVs

Warehouse capacity

Architecture

• Burstable capacity
• Pause and resume
• Smoothing and throttling
• Workload Management

Data recovery

Architecture

• Restore in-place
• Clone tables
• Clone tables in the Fabric portal

Best practices

Architecture

• Warehouse performance
• SQL analytics endpoint performance
• Security
• Ingest Data