How to run/trigger sql scripts with serverless pool (remotely.. with api's or any other way then synapse workspace)

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
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.
4,668 questions
{count} votes