Configuring Azure ADLS Integration

Snowflake · Cloud Integrations

Theory

CREATE STORAGE INTEGRATION ... STORAGE_PROVIDER = 'AZURE' records your AZURE_TENANT_ID and the allowed container paths. Running DESC INTEGRATION then shows AZURE_CONSENT_URL and AZURE_MULTI_TENANT_APP_NAME. An Azure admin opens the consent URL and accepts, which adds Snowflake's application to your tenant as a service principal. In the Azure portal you then assign that service principal a Storage Blob Data role on the container.

Once consent and the role are in place, you create external stages with STORAGE_INTEGRATION = azure_integration and a URL inside the allowed locations. One integration can serve many stages, for example one per folder or container.

Why we use it

This handshake gives Snowflake access without storing an account key or SAS token in SQL. Access is controlled in Azure, and removing the role assignment immediately cuts Snowflake off.

When to use it

Use this for all production Azure stages. A SAS token in CREATE STAGE is acceptable only for quick tests. Create one integration per tenant and set of allowed locations, and reuse it across stages.

Creating the Storage Integration Object

CREATE STORAGE INTEGRATION links Snowflake to your Azure tenant ID and target container in one statement, mirroring the AWS storage integration pattern.

The Consent Step

Running DESC INTEGRATION afterward reveals a consent URL that an Azure admin must open and approve — without this step, Snowflake's application has no actual permission yet.

Reusing One Integration

A single integration object can back multiple external stages pointed at different containers or folders inside its allowed locations, so you don't need to repeat the consent and role-assignment steps for every new data source.

How it works

  1. CREATE STORAGE INTEGRATION with tenant ID and allowed locations
  2. DESC INTEGRATION to read the consent URL and app name
  3. Azure admin opens the consent URL and accepts
  4. Assign the Snowflake service principal a Blob Data role on the container
  5. CREATE STAGE using the integration
  6. Does LIST @my_azure_stage return files? Yes: Grant stage usage and start loading. No: Recheck consent, role scope and URL.
  7. Integration is ready for reuse

Example

DESC INTEGRATION azure_integration;
-- AZURE_CONSENT_URL: open this to grant Snowflake access
-- AZURE_MULTI_TENANT_APP_NAME: grant this app access to your container

CREATE OR REPLACE STAGE my_azure_stage
  STORAGE_INTEGRATION = azure_integration
  URL = 'azure://myaccount.blob.core.windows.net/mycontainer/data/'
  FILE_FORMAT = my_csv_format;

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