Reference .SQL file in Pipeline (w/ Git Integration)
Create the ability to reference a .SQL file within Fabric Pipeline. In the Copy Data wizard, a button should be added when configuring the connection to the data source. If "Query" is selected, then there should be a button appear next to "Preview Data" that allows the user to open the file explorer and search for a .SQL which will then be imported into the copy data activity. A much more powerful feature would be to not import the .SQL file contents but allow Pipeline to reference the .SQL file directly from a remote repository like Git. This will allow developers to version control their queries used in the Copy Data activity outside of the Pipeline. An additional helpful feature would be integration with a remote repository to allow a series of .SQL files to be referenced which would create a metadata driven pipeline via custom sql scripting.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Support Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi51 minutes agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K3 hours agoMicrosoft EmployeeNew19Views6likes0CommentsInvoke Pipeline Task - Workspace Identity Authentication
Currently, the Fabric Data Factory Invoke Pipeline task uses the user's credentials who saved the pipeline to then authenticate to the Azure Data Factory to execute the ADF pipeline. When that user'...dzebrowitz7 hours agoAdvocate IPlanned1.8KViews61likes5CommentsFabric Pipeline should run as workspace identity
Currently, Microsoft Fabric pipelines run under the identity of the last user who modified them, which can cause disruptions when tenant administrators make changes to security policies, such as enab...pellitteris7 hours agoAdvocate IINew1.4KViews27likes3CommentsBring Back separating Power BI artifacts on a per web page basis
Previously, the ability to have different artifacts open on different web tabs was enabled. This was beneficial if you wanted to differentiate what environments you were in, working across three diff...zoe-dean9 hours agoNew MemberNew55Views8likes0Comments