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';
