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!