How do you connect Databricks with a storage account?

Question

Accepted Answer

To connect data bricks with storage account, you need to create a storage account and configure it in the data bricks workspace.

Create a storage account in Azure portal
Get the connection string of the storage account
In the data bricks workspace, go to 'Storage' and click on 'Create'
Select the storage account type and provide the connection string
Test the connection and save the configuration

Accepted Answer

To connect Azure Databricks with an Azure Storage Account, 
we are going to use 
1️⃣ Mounting Azure Blob Storage (DBFS Mounting)
storage_account_name = "yourstorageaccount"
container_name = "yourcontainer"
access_key = "your_storage_access_key"

# Mount the Azure Blob Storage
dbutils.fs.mount(
    source = f"wasbs://{container_name}@{storage_account_name}.blob.core.windows.net/",
    mount_point = f"/mnt/{container_name}",
    extra_configs = {f"fs.azure.account.key.{storage_account_name}.blob.core.windows.net": access_key}
)

Asked in Wipro

How do you connect Databricks with a storage account?

Top Azure Data Engineer Interview Questions Asked at Wipro

Interview Questions Asked to Azure Data Engineer at Other Companies

Top Skill-Based Questions for Wipro Azure Data Engineer