SQL Pools missing in the data flows source settings

Synapse 21 Reputation points
2020-12-24T10:55:07.62+00:00

Hi, I have created a couple dedicated sql pools within the synapse workspace with a view to load data from one poll to the other. However, the sql pools doesn't show in the source type (inline). Can you help please? I wonder if I need to add an extension as I vaguely remember doing it for Azure Database for PostgreSQL and its there.51020-screenshot-2020-12-24-at-105144.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,980 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,814 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,746 Reputation points
    2020-12-24T15:06:49.053+00:00

    Azure synapse pools is not supported as of now as inline datasets. It's given in the below document. Probably you can try using dataset option from the dropdown

    https://learn.microsoft.com/en-us/azure/data-factory/data-flow-source#supported-sources

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.