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

Staying_Updated_with_IntelliSense_in_Fabric_Warehouse

• 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!