Preparing Azure ADLS Integration

Snowflake · Cloud Integrations

Theory

Before connecting Snowflake to Azure storage, gather a few things. You need your Azure tenant ID (from Microsoft Entra ID, formerly Azure AD), the storage account and container name, and the path Snowflake should read. Snowflake URLs for Azure use the form azure://<account>.blob.core.windows.net/<container>/<path>, for both Blob storage and ADLS Gen2.

Access is granted through Azure role-based access control. Snowflake provides a multi-tenant application; once an admin consents to it, it appears in your tenant as a service principal, and you give it a role such as Storage Blob Data Reader (read only) or Storage Blob Data Contributor (needed to unload or purge files) on the container or storage account.

Why we use it

Preparing the Azure side first avoids the most common integration failures: wrong tenant ID, wrong URL format or missing role assignments. It also lets the Azure admin approve exactly the access Snowflake needs.

When to use it

Do this before creating the storage integration whenever data lives in Azure storage. Decide early whether Snowflake only reads (Reader) or also writes (Contributor), and scope the role to the container rather than the whole account.

Consenting to Snowflake's Azure App

After you create the storage integration, DESC STORAGE INTEGRATION returns an AZURE_CONSENT_URL and an AZURE_MULTI_TENANT_APP_NAME. Opening the consent URL as an Azure admin adds Snowflake's multi-tenant service principal to your tenant — you do not register an app yourself.

Granting Container Access

Give that service principal the Storage Blob Data Reader role (or Storage Blob Data Contributor if Snowflake must also unload or purge files) on the storage account or container — the Azure equivalent of an AWS IAM role, with no keys stored in Snowflake.

Blob Storage and ADLS Gen2

The same integration works for Azure Blob Storage and ADLS Gen2 (Blob Storage with a hierarchical namespace). Use the azure://<account>.blob.core.windows.net/<container>/ URL form in STORAGE_ALLOWED_LOCATIONS and stage URLs.

How it works

  1. Data lives in an Azure storage container
  2. Note the tenant ID from Microsoft Entra ID
  3. Note the storage account, container and path
  4. Will Snowflake also unload or delete files? Yes: Plan the Storage Blob Data Contributor role. No: Plan the Storage Blob Data Reader role.
  5. Find an Azure admin who can grant consent and role assignments
  6. Ready to create the storage integration

Example

CREATE OR REPLACE STORAGE INTEGRATION azure_integration
  TYPE = EXTERNAL_STAGE
  STORAGE_PROVIDER = 'AZURE'
  ENABLED = TRUE
  AZURE_TENANT_ID = 'your-azure-tenant-id'
  STORAGE_ALLOWED_LOCATIONS = ('azure://myaccount.blob.core.windows.net/mycontainer/data/');

Key points

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic