Snowflake × Azure ADLS Integration Guide

Snowflake · Cloud Integrations

Theory

The full Azure setup is a chain, and each link depends on the one before it. First prepare the Azure side (tenant ID, container, path). Then create the storage integration in Snowflake and run DESC INTEGRATION. An admin opens the consent URL, and you assign Snowflake's service principal a Storage Blob Data role on the container. Next create a file format and an external stage using the integration, grant USAGE on the integration and stage to the loading role, and finally run COPY INTO.

Most failures come from one broken link: consent not granted, the role assigned at the wrong scope, a URL outside STORAGE_ALLOWED_LOCATIONS, or the loading role missing USAGE. Testing with LIST after each step finds the problem quickly.

Why we use it

Seeing the whole sequence prevents half-finished setups and makes debugging systematic. When a load fails, you can walk the chain in order instead of guessing.

When to use it

Use this as a checklist for every new Azure source and when a previously working load starts failing with access errors. For several containers, reuse one integration and add stages.

The Full Setup Sequence

Note the tenant ID and container path, run CREATE STORAGE INTEGRATION, open the AZURE_CONSENT_URL from DESC STORAGE INTEGRATION as an Azure admin, assign Snowflake's service principal a Storage Blob Data role on the container, create an external STAGE on that integration, then COPY INTO your table. You never register your own Azure app.

Where Setups Usually Break

A single misconfigured RBAC role at the container level is the most common point of failure — DESC STORAGE INTEGRATION is the most useful command for debugging a stalled connection.

Validating Each Step

Test the stage independently with LIST @stage_name before attempting a full COPY INTO, so a permissions problem shows up immediately rather than mid-load.

How it works

  1. Prepare tenant ID, container and path
  2. CREATE STORAGE INTEGRATION and DESC it
  3. Grant admin consent and assign the Blob Data role
  4. Create the file format and external stage
  5. Does LIST @stage work as the loading role? Yes: Run COPY INTO the table. No: Check consent, role scope, allowed locations and grants.
  6. Load succeeds; schedule it or add Snowpipe

Example

-- 1. Note tenant ID, storage account, container and path
-- 2. CREATE STORAGE INTEGRATION ... STORAGE_PROVIDER = 'AZURE'
-- 3. DESC STORAGE INTEGRATION -> open AZURE_CONSENT_URL as an Azure admin
-- 4. Assign Storage Blob Data Reader/Contributor to the Snowflake service principal
-- 5. CREATE STAGE ... STORAGE_INTEGRATION = azure_integration
-- 6. LIST @stage, then COPY INTO

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