'can we execute sql query in serverless pool from pipeline azure synapse?
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.
Solution 1:[1]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Jason Campbell |