Shipped (Q4 2024)
Release Type: General availability
Using the public REST APIs to create a Data Warehouse includes a new option to set the default collation. This can be used to set a new Case Insensitive Collation default. The two supported collations are Latin1_General_100_CI_AS_KS_WS_SC_UTF8 (which is Case Insensitive) and Latin1_General_100_BIN2_UTF8 (which is Case Sensitive) and continues to be our default.
COLLATE T-SQL clause support is coming soon. This will enable you to utilize the COLLATE command with CREATE or ALTER TABLE to directly specify the collation for your VARCHAR fields.
Nested CTEShipped (Q4 2024)
Common Table Expressions (CTE) increases the readability and simplification for complex queries by deconstructing ordinarily complex queries into simple blocks to be used and reused if necessary, instead of rewriting the query. A nested CTE is defined with the definition of another CTE.
T-SQL Notebook integrationShipped (Q3 2024)
Release Type: Public preview
You can start using T-SQL language support within Notebooks which combines the power of Notebooks and SQL within the same experience - enabling intellisense, autocomplete, cross database queries, richer visualizations and the ability to easily collaborate and share using Notebooks.
TRUNCATEShipped (Q3 2024)
The TRUNCATE command quickly removes all rows of data from a table.
ALTER TABLE - Add nullable columnShipped (Q3 2024)
Support for ALTER TABLE ADD COLUMN to be able to extend already existing tables with new columns that allow NULL values.
Query insights updatesShipped (Q3 2024)
A historic view of your closed sessions will be made available via Query Insights. This addition it helps you analyze traffic, load, and usage of your DW.
In-place restore within warehouse editorShipped (Q2 2024)
You can now easily create restore points and restore the warehouse to a known good state in the event of accidental corruption, using the Warehouse editor experience.
COPY INTO support for secure storageShipped (Q2 2024)
Release Type: Public preview
You can now ingest data into your Warehouse using COPY INTO from an external Azure storage account that is protected behind a Firewall.
CopilotShipped (Q2 2024)
Release Type: Public preview
Copilot enables developers of any skill level to quickly build and query a warehouse in Fabric. Copilot offers advice and best practices, autocomplete code, help fix and document code, and offer assistance with data prep, modeling, and analysis.
Time travelShipped (Q2 2024)
The ability to time travel at the T-SQL statement level empowers users to query historical data from various past timeframes by specifying the timestamp only once for the entire query. Time travel helps save significantly on storage costs by using single copy of data present in One Lake for conducting historical trend analysis, troubleshooting, and data reconciliation. Additionally, it also facilitates achieving stable reporting by upholding the data integrity across various tables within the data warehouse.
Warehouse monitoring experienceShipped (Q2 2024)
Using the built-in warehouse monitoring experience, you can view both live queries and historical queries, monitor, and troubleshoot performance of their end-to-end solution.