Data warehousing documentation in Microsoft Fabric

Data warehousing

Overview

• Overview
• Better together - the lakehouse and warehouse

Get started with Data Warehouse

Tutorial

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

Security

Concept

• Data warehousing 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
• Semantic 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
• 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

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

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