Azure Synapse Studio - Browsing a VNet isolated Data Lake

fmms 6 Reputation points
2021-03-19T22:37:58.057+00:00

Hi,

I want to use Synapse Studio to access a data lake that is in a VNet. For this I have created a workspace with the Managed VNet option. For the pipelines within Synapse this works well. I can preview files on the data lake.

However, the file system browser that is integrated in the Synapse Studio does not leverage the Integration Runtime that is configured in its linked service.
79764-image.png

As a result it is not working at all.
79783-image.png

Are there any tricks to make that happen?

Thanks alot

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,425 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,675 questions
{count} vote

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 85,351 Reputation points Microsoft Employee
    2021-03-22T08:41:59.033+00:00

    Hello @fmms ,

    Welcome to the Microsoft Q&A platform.

    To resolve this issue, you need to have proper rights to access on the Storage Account.

    Easiest way is to grant Storage Blob Data Contributor role to the Managed identity name fmsynwsp you're trying to access.

    Go to storage account => Access Control (IAM) => Add => Add role assignment => Select Role Storage Blob Data Contributor => Select Managed identity name fmsynwsp and click on save.

    80089-image.png

    For more details, refer:

    Visit full guide on Azure Active Directory access control for storage for more information

    Visit Control storage account access for serverless SQL pool in Azure Synapse Analytics.

    Note: Before you create a linked service, click on Test connection button to verify the connection.

    80119-image.png

    Once you had granted permission on the storage account, you will be able to access the storage account in synapse workspace.

    80090-image.png

    Hope this helps. Do let us know if you any further queries.

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

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