Are synapse lake database views not accessible by external tools like Visual Studio with SSDT?

Question

Are synapse lake database views not accessible by external tools like Visual Studio with SSDT?

KDupre 20

We are trying to create an Analysis Services tabular model that points to a synapse serverless SQL pool in order to access the tables and views in a Lake Database. We can see the tables in the Lake Database but not the views. Is there a limitation? I cannot find any documentation on this.

KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2023-11-28T21:45:24.2933333+00:00

@KDupre Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you

Accepted answer

0 additional answers

Your answer

KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2023-11-28T21:45:24.2933333+00:00

@KDupre Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you

Answer 1

Hi KDupre,

Yes, there is currently a limitation with Synapse Lake Database views that prevents them from being directly accessible by external tools like Visual Studio with SSDT. This is because Synapse Lake Database views are stored as metadata in the Spark catalog rather than as SQL objects in the serverless SQL pool. As a result, they are not visible to tools that connect to the serverless SQL pool using standard SQL protocols.

There are two things you can use to access Synapse Lake Database views from external tools:

Use the Synapse Workspace web UI to create a SQL Server view based on the Lake Database view.
Use a tool like Azure Data Factory or Azure Synapse Pipelines to create a data flow that queries the Lake Database view and outputs the results to a staging table in the serverless SQL pool.

Regards,

Share via

Are synapse lake database views not accessible by external tools like Visual Studio with SSDT?

0 additional answers

Your answer