Is it possible to connect Visual Studio Code with Synapse Analytics ?

kosmos 246 Reputation points
2022-10-11T07:37:38.573+00:00

I want to query the SQL dedicated pool that I created in Synapse Analytics with Visual Code Studio

I connected Visual Code Studio without any problems to Azure SQL Database, but I did not find any official documentation to connect Visual Code Studio to Synapse Analytics,

Is it even possible ?

My objective is to control all the code in my Data Warehouse in Visual Code Studio so I can push all the changes to Github.

I do not want to use the Github connection in Synapse Analytics interface directly because I want to only have one place to push all the code.

Thanks in advance!

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,472 questions
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 27,656 Reputation points Microsoft Employee
    2022-10-11T19:59:58.34+00:00

    Hello @kosmos ,

    Welcome to the MS Q&A platform.

    Yes, you can use VS code to connect to the Synapse SQL dedicated pool.

    Steps:

    From the VS code extensions, look for SQL tools.

    Install SQL tools, then you will see the database symbol option on the left side menu(from here, you can connect to the Synapse SQL).

    After installing the SQL tools, you will need to install the SQL driver. Click on the database symbol; you will see the options to install the SQL driver.

    If you want to use Visual Studio to connect to the synapse SQL, the steps are documented here

    I hope this helps.

    Please let me know if you have any further questions.

    249454-image.png

    ------------------------------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful