Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
Can we use SQL scripts located in Develop hub during pipeline creation in azure synapse?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 85%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Georgi Chervenski (Accedia)
20
Reputation points
Hi Team,
I have created several SQL scripts in the Develop hub in Azure Synapse Studio.
My aim is to find a way to run those sql scripts using a pipeline in Azure Synapse.
Can you help me with that?
Are there any other ways to interact with those sql scripts outside the Develop hub?
Thanks in advance!
Best regards,
Georgi.
Azure Synapse Analytics
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,366 Reputation points Moderator2023-11-01T19:19:08.51+00:00 Hello @Georgi Chervenski (Accedia),
What is your motivation to call a SQL Script directly from the Pipeline?
We have the options to Run a Script with direct SQL Query
Or we can leverage the SQL Pool's Stored proc!
Please let me know if these are helpful with your initial query? -
Georgi Chervenski (Accedia) 20 Reputation points
2023-11-02T07:30:29.5133333+00:00 Hi,
We are implementing source control in Azure Synapse. We have two environments - test and prod. There is a dedicated SQL Pool in each environment. I was trying to add the tables (CREATE scripts) and the stored procedures scripts in the source control. I added the scripts manually to the Develop hub and I want to run them using a pipeline or something to refresh the tables and SPs metadata. I couldn`t find how to add the stored procedures from the SQL pool to the source control. I figured out that only the scripts that appear in the Develop hub are added to the source control. We are using Azure DevOps to implement the source control.
Is there another solution for adding the stored procedures from the SQL pool into the source control?
We need to track all the changes on the stored procedures and the tables in the SQL pool and add them in the source control, if it is possible.
-
QuantumCache 20,366 Reputation points Moderator
2023-11-15T04:43:38.9033333+00:00 @Georgi Chervenski (Accedia)
Is there another solution for adding the stored procedures from the SQL pool into the source control?You can use the SQL Server Management Studio (SSMS) to generate the CREATE scripts for the stored procedures and tables in the dedicated SQL pool, and then add those scripts to your source control repository.
Did you think about this way? I am just thinking if that helps with your scenario/
Sign in to comment
Sign in to answer