T-SQL Notebooks is one of the new features announced during FabCon Europe.
The most distracted could miss the fact this is a new feature at all. Yes, it is. Notebooks were capable to support Spark SQL, but T-SQL is something new.
The main examples being announced are built with data warehouses, but let me confirm and highlight this:
T-SQL Notebooks support lakehouses as well.
There is at least one limitation: DML is not supported with lakehouses.
Let’s start from the beginning.
The T-SQL Notebooks UI
The easiest way to create a T-SQL notebook is using the button “New Query”