An internal stage is a Snowflake staging object whose data files reside in cloud storage managed for the Snowflake account. It provides a landing point between local files and Snowflake tables. section 2.2
Use internal stages to:
- Upload CSV files before loading them into a staging table with COPY. section 2.0 section 2.6
- Inspect staged files with LIST or query staged data using SELECT and the $ column notation. section 2.2 section 2.6
- Choose among user stages, table stages, and named internal stages; named stages support files managed by multiple users and loaded into multiple tables. section 2.2
Create and inspect a named internal stage
use database BAKERY_DB; use schema ORDERS; create stage ORDERS_STAGE; list @ORDERS_STAGE;
Figure 2.1 Data pipeline that takes CSV files from a Snowflake internal stage, loads the data into a staging table, merges the data from the staging table into the target table, and transforms the data for downstream consumption
Trace the internal stage’s role in a pipeline from CSV files through staging, merging, transformation, and downstream consumption. section 2.0
