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,384 questions
How to run/trigger sql scripts with serverless pool (remotely.. with api's or any other way then synapse workspace)
![](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(92.8, 80%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
Fourbends PL
0
Reputation points
I'm currently dealing with a scenario in Azure Synapse, I have a set of SQL scripts within my Azure Synapse workspace, and these scripts are designed for various environments like stage, test, and prod, all residing within the same replicated Synapse workspace. Now, the challenge I'm facing is finding an efficient way to run all these SQL scripts from their respective environments within a single pipeline. I wanted to know if any of you have tackled a similar use case and what approach or best practices you'd recommend for streamlining this process.
Any insights, tips, or shared experiences would be incredibly helpful!
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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator2023-12-06T23:07:03.2933333+00:00 Hello Fourbends PL,
Welcome to the microsoft Q&A forum.
After further research I have not found any powershell commands or by API call to run the sql scripts remotely with serverless SQL pool.
Here is one approach for your ask:
- Get the SQL script using API call or directly from the Git repo. https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/sql-script/get-sql-script?view=rest-synapse-data-plane-2020-12-01&tabs=HTTP
- Run the script against the respective Serverless SQL pool using it's endpoint name
I hope this helps.
-
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2023-12-08T21:25:32.2666667+00:00 Hello Fourbends PL,
I am checking to see if the above response is helpful. Please let me know if you have any further questions.
-
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2023-12-11T21:12:06.36+00:00 Hello Fourbends PL,
I am checking to see if you have any further questions here.
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
-
Fourbends PL 0 Reputation points
2023-12-27T05:01:39.8433333+00:00 Hi @Bhargava-MSFT , we tried these methods. but unfortunately we were only able to get the scripts using the GET api's. we could not be able to run the scripts.
-
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2023-12-27T18:41:41.3533333+00:00 Hello Fourbends PL,
Get API should work to get the sql scripts from synapse.
Can you please follow the below stackoverflow thread and see if it helps
Sign in to comment
Sign in to answer