4

Can we execute SQL query in the serverless pool from the pipeline in Azure Synapse?

We are trying to run the SQL query in the Synapse pipeline, we are not able to find a way to execute the same from the pipeline using the serverless pool.

CHEEKATLAPRADEEP
  • 12,191
  • 1
  • 19
  • 42
Dheeraj Bharambe
  • 43
  • 1
  • 7

1 Answers1

3

Sure. Set up an Azure SQL Database linked service to SQL Serverless (Instead of the Azure Synapse Analytics one, which is used for dedicated sql pool). Check this out: https://www.youtube.com/watch?v=NlYNcAduQxE&t

Jason Campbell
  • 146
  • 1
  • 10
  • This of course works, but Synapse does not have a built-in way to call a script which was developed as an sqlscript in the workspace. The only way to do this currently is to call the synapse workspace rest api to fetch the script and execute it. – adrien Oct 28 '22 at 05:51