Explore data in your mirrored database directly in OneLake

You can access mirrored database table data in Delta format files. This tutorial provides steps to connect to Azure Cosmos DB data directly with Azure Storage Explorer.

Prerequisites

• Complete the tutorial to create a mirrored database from your source database.
  • Tutorial: Create a mirrored database from Azure Cosmos DB
  • Tutorial: Create a mirrored database from Azure SQL Database
  • Tutorial: Create a mirrored database from Snowflake

Access OneLake files

1. Open the Mirrored Database item and navigate to the SQL analytics endpoint.
2. Select the ... dots next to any of the tables.
3. Select Properties. Select the copy button next to the URL.
4. Open the Azure Storage Explorer desktop application. If you don't have it, download and install Azure Storage Explorer.
5. Connect to Azure Storage.
6. On the Select Resource page, select Azure Data Lake Storage (ADLS) Gen2 as the resource.
7. Select Next.
8. On the Select Connection Method page, Sign in using OAuth. If you aren't signed into the subscription, you should do that first with OAuth. And then access ADLS Gen2 resource.
9. Select Next.
10. On the Enter Connection Info page, provide a Display name.
11. Paste the SQL analytics endpoint URL into the box for Blob container or directory URL.
12. Select Next.
13. You can access delta files directly from Azure Storage Explorer.

Tip

More examples:

• Integrate OneLake with Azure Databricks
• Access Fabric data locally with OneLake file explorer
• Use OneLake file explorer to access Fabric data

Related content

• Explore data in your mirrored database using Microsoft Fabric
• Explore data in your mirrored database with notebooks
• Connecting to Microsoft OneLake