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
Deployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v1 hour agoCommunity ChampionNew6KViews137likes17CommentsNative Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles1 hour agoRegular VisitorNew212Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi2 hours agoRegular VisitorNew3Views0likes0CommentsDeployment Pipelines - Remember selected stage
Every time we go into a deployment pipeline, it defaults to selecting the Development stage. I believe that it would be very rare to have a user select the Development stage. It would be helpful if d...PeterDaniels9 hours agoAdvocate IINew2Views1like0Comments