With notebook based code picking up significant adoption off late, and multiple competitor products offering similar interface, adding support for T-SQL notebooks unlocks a host of possibilities.
- T-SQL notebooks could help make code easily understandable and maintainable (usage of markdown etc.) as against maintaining same through SQL script files or Queries.
- Uniformity amongst Spark and SQL based code base.
- Modularity: Temporary views/ functions can be put inside single notebook and referenced from other notebooks.
- Promote reusability via cross warehouse usage.
- Orchestration possible through Data factory.
- With Git integration in Spark/SQL notebooks CI/CD is seamless.
6 Comments
- fbcideas_migusrNew Member
Great idea, thanks for raising!
- fbcideas_migusrNew Member
Hi,
I hope that a such feature could be released as soon as possible. Thanks
- h_schraderNew Member
Support for git for T-SQL Notebooks would be great to have.
- nishalitNew MemberThank you for submitting the idea.
This idea is in plan and you can see release timelines here: What's new and planned for Synapse Data Warehouse in Microsoft Fabric - Microsoft Fabric | Microsoft LearnThanks,
Priyanka - fbcideas_migusrNew MemberStatus added:Planned
- prlMicrosoft EmployeeStatus changed:PlannedtoCompleted
T-SQL support in Notebook is available to use Author and run T-SQL notebooks in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
Recent ideas
Support Native SQL LIKE / NOT LIKE Wildcard Filtering Across Power BI Reports
Description Currently, Power BI does not provide a native way for report consumers to perform dynamic SQL-style wildcard filtering using patterns such as LIKE '____' - Above return all values wit...Seeralan50 minutes agoNew MemberNew4Views0likes0CommentsRetain Matrix/Table Scroll Position When Returning from Drillthrough
Description: Currently, when users drill through from a Matrix or Table visual to a detailed page and then use the Back button to return, the report navigates back to the source page but resets the ...Pruthviraj152 hours agoNew MemberNew8Views0likes0Comments