Dheeraj Bharambe
Reputation: 63
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.
Upvotes: 6
Views: 4726
Answers (1)
Jason Campbell
Reputation: 146
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
Upvotes: 3
Related Questions
- Error while trying to query external tables in Serverless SQL pools
- Can I create a stored procedure in serverless sql pool
- Execute simple SQL query though Azure Devops CICD pipeline
- Pipeline keeps failing in Azure Synapse (running a simple query)
- Azure synapse, SQL pool as a source in dataflow
- Unable to Query Serverless Pool View in Azure Synapse using SQL Admin Credentials
- Can I Query a SQL Server Database from Azure Synapse Without Using a Pipeline?
- Join data in Azure Synapse from dedicated sql pool and serverless sql pool
- Running query using serverless sql pool (built-in) on CSV file in Azure Data Lake Storage Gen2 failed
- How to query Azure SQL DB from Azure DevOps Pipeline?