Snowflake Internal Stages

Snowflake · Staging & SnowSQL

Theory

A stage is a named location holding files that Snowflake loads from or unloads to. Internal stages live in Snowflake-managed storage and come in three kinds: the user stage (@~), private to each user; the table stage (@%orders), tied to one table; and named stages (@my_stage), created with CREATE STAGE and shareable through grants. External stages point at your own S3, Azure or GCS location.

The workflow is the same for all of them: upload files with PUT (internal only), check them with LIST, load with COPY INTO and clean up with REMOVE. For example, PUT file:///data/orders.csv @my_stage, then COPY INTO orders FROM @my_stage.

Why we use it

Snowflake loads data from files in bulk, and those files need a place to sit first. Internal stages give you that place without owning any cloud storage account or setting up credentials.

When to use it

Use a named internal stage for files uploaded from laptops, scripts or apps, and for shared loads. Use user or table stages for quick personal work. Use an external stage when the files already live in your cloud bucket.

What a Stage Is

A stage is simply a named storage location Snowflake reads from or writes to when loading and unloading files — think of it as a waiting room for data before it becomes table rows.

Types of Internal Stages

Every user automatically gets a personal stage (@~), every table gets a table stage (@%table_name), and you can also create a named stage shared across a schema — pick based on whether the files belong to one user, one table, or a whole pipeline.

Typical Workflow

Files are PUT onto a stage, optionally validated, then loaded into a table with COPY INTO — the same three-step flow whether the stage is internal or points at an external cloud bucket.

How it works

  1. Local file ready to load
  2. Do several users or tables need this stage? Yes: Create a named stage with CREATE STAGE. No: Use the user stage @~ or table stage @%table.
  3. PUT the file to the stage (compressed by default)
  4. LIST the stage to confirm the file is there
  5. COPY INTO the target table
  6. REMOVE or PURGE loaded files

Example

CREATE OR REPLACE STAGE my_stage COMMENT = 'Stage for loading CSV files';
CREATE OR REPLACE STAGE my_dir_stage DIRECTORY = (ENABLE = TRUE);

LIST @~;
LIST @my_stage;
LIST @%orders;
REMOVE @my_stage/old_file.csv;

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