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.
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