Share via

Is it possible to create an external data source in Synapse Dedicated SQL Pool to read data from a SQL Managed Instance?

Hilmi Ekici 0 Reputation points
2024-04-01T08:57:29.2666667+00:00

Is it possible to create an external data source in Synapse Dedicated SQL Pool to read data from a SQL Managed Instance?

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.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 41,116 Reputation points Volunteer Moderator
    2024-04-01T09:42:44.13+00:00

    Based on this old thread :

    You need to set up a Linked Service for Azure SQL Database Managed Instance in Synapse:

    So start by creating the linked service within your Synapse workspace that targets your Azure SQL Database Managed Instance. This connection facilitates interaction between Synapse and the SQL Database, enhancing your data management capabilities.

    How to configure a Spark Pool in Synapse?

    Proceed to create a Spark pool within your Synapse workspace. This component specifies the computational resources allocated for Spark sessions, with adjustable parameters like node count, node dimension, and auto-scaling options. Node sizes vary from small to XXLarge, catering to diverse project demands. For tasks necessitating enhanced isolation, the XXXLarge node size offers an Isolated Compute feature.

    How to integrate the Spark Pool with Your Synapse Notebook?

    Access your Synapse Notebook and head to the Compute section. Under Attached computes, opt for the Synapse Spark pool. This integration allows your notebook to leverage the Spark pool for executing Spark operations on data sources, inclusive of the Azure SQL Database Managed Instance.

    https://learn.microsoft.com/en-us/azure/machine-learning/how-to-manage-synapse-spark-pool?view=azureml-api-2&tabs=studio-ui%22https://learn.microsoft.com/en-us/azure/machine-learning/how-to-manage-synapse-spark-pool?view=azureml-api-2&tabs=studio-ui%22

  2. PRADEEPCHEEKATLA 91,496 Reputation points Moderator
    2024-04-01T09:44:44.22+00:00

    @Hilmi Ekici - Thanks for the question and using MS Q&A platform.

    No, it is not possible to create an external data source in Synapse Dedicated SQL Pool to read data from a SQL Managed Instance.

    External data sources are used to reference external data stores such as Azure Blob Storage, Azure Data Lake Storage, and Azure SQL Database.

    User's image

    To read data from a SQL Managed Instance, you can use the PolyBase feature in SQL Server or Azure Synapse Analytics. PolyBase allows you to query data from external data sources such as SQL Managed Instance, Oracle, Teradata, and Hadoop.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Your answer

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