l_obr
Reputation: 41
Azure synapse, SQL pool as a source in dataflow
I try to use Serverless Sql Pool Integration dataset in Azure Analitycs DataFlow as a source but I can't. SQL Pool is unavailable as a Source in DataFlow, but I don't know why?
What is a problem? I use SQL Pool datasets in Azure Synapse Pipelines and it works. Is it problem with my licence, version or maybe I do something wrong?
Upvotes: 0
Views: 576
Answers (1)
Pratik Somaiya
Reputation: 733
Have you tried selecting Synapse Dataset instead of SQL
You will need a Synapse Linked Service as well
Upvotes: 1
Related Questions
- Connecting from Azure Synapse Analytics Spark Pool to Azure SQL Database
- cross database access in azure synapse sql pools
- Not able to transform and load from ADLS(csv) to Dedicated SQL Pool by using Azure Synapse's Dataflow
- OPENROWSET() for Synapse dedicated pools?
- Can you use a data flow sink as a source in the same data flow?
- Azure Synapse dedicated sql pool not showing data objects in synapse studio
- azure synapse - serverless sql pool databases not visible in data tab
- The sql codes shown in the document is not running on azure synapse dedicate sql pool
- Stream output data from Stream Analytics Job to Azure Synapse Analytics sql pool table?
- Join data in Azure Synapse from dedicated sql pool and serverless sql pool