Share via

Azure Data Studio

arkiboys 9,691 Reputation points
2021-07-28T06:42:35.887+00:00

Hello,
In synapse analytics, we have created views in SQL Scripts to read the .parquet files...
Question:
Using Azure Data Studio, is it possible to execute those views? if so, how?
I ask because in Data studio, I do not see how to change the connection to the synapse views we created.

Thank you

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,919 questions
0 comments
Accepted answer
  1. KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee
    2021-07-28T18:46:14.587+00:00

    Hi @arkiboys ,

    Thanks for using Microsoft Q&A forum and posting your query.

    Just wanted to check if you were able to establish connection to Synapse SQL endpoint from Azure Data Studio? If not, you can execute any TSQL code via Azure Data Studio by connecting to Synpase SQL endpoint as described in this document: Connect to Synapse SQL with Azure Data Studio. You can execute a query where view is an object from which you get data.

    Hope this info helps. Do let us know if you have further query.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.