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

KDupre 20 Reputation points
2023-11-24T05:44:37.6866667+00:00

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.

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

Accepted answer
  1. Osjaetor 475 Reputation points
    2023-11-27T12:29:05.3733333+00:00

    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:

    1. Use the Synapse Workspace web UI to create a SQL Server view based on the Lake Database view.
    2. 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,

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful