Fabric Data Warehouse documentation

Learn about Fabric Data Warehouse, a fully managed, scalable data warehouse solution.

About Data Warehouse

Overview

• Overview
• Better together - the lakehouse and warehouse
• Architecture

Get started with Data Warehouse

Tutorial

• End to end tutorials
• Data Warehouse tutorial
• Create a warehouse quickstart

Security

Concept

• Warehouse security
• Connectivity
• Microsoft Entra ID authentication
• Workspace roles
• SQL granular permissions
• SQL audit logs
• Row-level security
• Column-level security
• Share your data
• Encryption

Ingest data

How-To Guide

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

Concept

• Mirroring
• Database Mirroring in Fabric
• Mirroring Azure SQL Database
• Mirroring Azure SQL Managed Instance
• Mirroring Azure Cosmos DB
• Mirroring Databricks
• Mirroring Snowflake
• Mirroring SQL Server
• Open mirroring
• Share and secure mirrored databases

Design and develop

Concept

• Development and deployment
• Warehouse projects in Visual Studio Code
• Semantic models
• Reports in the Power BI service

Query

Concept

• Use AI functions
• Query using the SQL Query editor
• Query with T-SQL
• Query delimited files
• Query external data lake files
• Query JSON files
• Query Parquet files
• View data in the Data preview
• Visual query editor
• Warehouse snapshots

Manage

How-To Guide

• Manage objects in a warehouse
• Statistics
• Query insights
• Caching
• Troubleshoot

Monitor

How-To Guide

• Capacity Metrics app
• Monitor using DMVs

Data 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

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

Migration

Deploy

• Migration Assistant
• Migrate planning for Azure Synapse Analytics dedicated SQL pools
• Migration​ methods for ​Azure Synapse Analytics dedicated SQL pools
• Migrate to Fabric