Loading Data from Azure ADLS

Snowflake · Cloud Integrations

Theory

Once an external stage points at an Azure container, loading works exactly as with S3 or GCS. COPY INTO orders FROM @my_azure_stage/orders/ FILE_FORMAT = my_csv_format reads the files, and the same options apply: PATTERN, FILES, ON_ERROR, VALIDATION_MODE and load metadata that skips files already loaded.

Only the stage definition is cloud-specific: the azure:// URL and the integration. Everything after that, including file formats, COPY options and transformations in the COPY SELECT, is the same. For continuous loading, Snowpipe on Azure uses Event Grid notifications through a notification integration, the counterpart of S3 event notifications.

Why we use it

Teams often have data in more than one cloud. Because COPY and file formats are cloud-neutral, you learn the load workflow once and only change the stage when the source moves.

When to use it

Use scheduled COPY from Azure stages for batch loads, and Snowpipe with Event Grid for continuous loads. Organise containers by date or source folder so PATTERN or path prefixes can load just the new data.

Same Workflow as S3

Once an external stage points at an ADLS container, COPY INTO loads files from it with the exact same syntax used for S3 or GCS — same file format objects, same pattern matching.

Switching Clouds Without Relearning

Because the load syntax doesn't change between providers, a pipeline written for S3 can point at ADLS instead with just a new stage definition — no rewritten COPY INTO logic.

Incremental Loading by Path

COPY INTO tracks already-loaded files by path just as it does for S3, so scheduled reruns against a growing ADLS container only pick up newly arrived files.

How it works

  1. Files arrive in the Azure container
  2. LIST @my_azure_stage/orders/ to check them
  3. COPY INTO orders with a file format and ON_ERROR rule
  4. Were any rows rejected? Yes: Inspect with VALIDATE() and fix the source. No: Continue.
  5. Schedule the COPY or move to Snowpipe with Event Grid

Example

COPY INTO orders FROM @my_azure_stage/orders/
FILE_FORMAT = my_csv_format
ON_ERROR = 'SKIP_FILE';

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