I have a LinkedIn service for SQL server and want to read data via synapse spark pool

ADITYA SINGH 0 Reputation points
2024-03-07T18:17:47.8133333+00:00

I have a LinkedIn service for SQL server and want to read data via synapse spark pool using the LinkedIn service which has all the credentials of the server.

Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,348 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,855 questions
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,395 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,599 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,391 Reputation points Microsoft Employee
    2024-03-07T20:39:09.69+00:00

    @ADITYA SINGH GODARA Thank you for reaching out.

    Yes, you can leverage the Azure Synapse Dedicated SQL Pool Connector for Apache Spark to achieve the above. Are you using service principal or a different auth method.?

    How to connect to a relational database like Azure SQL database and query data within a Synapse notebook. The authentication method used in the below link will be using service principal. You can check and change accordingly if you are using a different auth method.

    https://azuredataplatformnss.com/2021/09/06/using-azure-synapse-notebooks-to-connect-to-relational-databases/

    Regards,

    Oury