fabric-warehouse

What problem does it solve?

This Skill unit provides T-SQL commands and guidelines optimized for use with the Fabric Warehouse, offering comprehensive coverage for a range of data manipulation and analysis tasks on the Azure data platform.

Core Features & Use Cases

• Unsupported T-SQL Features Handling: Offers workarounds and best practices for unsupported features like FOR XML, recursive CTEs, triggers, etc.
• Schema Evolution: Describes operations for schema changes such as adding/dropping columns, renaming, altering table structure, and managing IDENTITY columns.
• Table Constraints and Limits: Detailed information on row size, table/column names, and constraints limitations in Fabric Warehouse.
• Transactions and Isolation: Guidance on transaction usage, supported isolation levels, and conflict resolution strategies.
• Time Travel and Snapshots: Describes time travel options and how to work with Warehouse Snapshots for data recovery and consistent queries.
• Performance Optimization: Provides best practices for table design, indexing, and query optimization to maximize performance in Fabric Warehouse.
• Data Ingestion and ETL: Guidelines on data ingestion and ETL processes tailored to Fabric Warehouse, including use of COPY INTO and bcp for bulk operations.

Quick Start

Run the T-SQL command against your Fabric Warehouse table to extract performance metrics and optimize table health:

EXEC sys.sp_get_table_health_metrics @table_name = 'your_table_name';