Staying Updated with IntelliSense in Fabric Warehouse
We’ve added in functionality to IntelliSense in Fabric. will enable developers to write queries efficiently using the new or updated T-SQL statements in Fabric Data Warehouse.
We’ve updated the IntelliSense for the following statements:
- Result-set Caching ALTER DATABASE <YourArtifactName> SET RESULT_SET_CACHING OFF | ON;
- Openrowset
- Alter Table – ALTER TABLE (Transact-SQL) – SQL Server | Microsoft Learn
- Table Clone – CREATE TABLE AS CLONE OF – SQL Server | Microsoft Learn
- Disable V-Order – Disable V-Order in Warehouse – Microsoft Fabric | Microsoft Learn
- Data_lake_log_publishing
- ALTER DATABASE CURRENT SET DATA_LAKE_LOG_PUBLISHING = AUTO
- ALTER DATABASE CURRENT SET DATA_LAKE_LOG_PUBLISHING = PAUSED
- Time Travel – Time travel in Warehouse within Microsoft Fabric – Microsoft Fabric | Microsoft Learn
- Create Table – Data Clustering
- Nested CTE – Nested Common Table Expression (CTE) in Fabric data warehousing – SQL Server | Microsoft Learn
Next Steps
Get started today
Get started with Data Warehouse: Query the Warehouse
Have a feature request? Post your thoughts to Ideas (microsoft.com).
Join us in this exciting journey to make data more accessible, understandable, and actionable for everyone in your organization. Thanks for reading!
