Output
Snowflake Output
Loads the rows into a Snowflake table — append, replace or upsert on key columns — in one transaction.
When to use it
Use it to load a dimension or fact table from a flow.
In a pipeline
File InputType ConversionSnowflake Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Load a dimension table
- Target Table=ANALYTICS.DIM_CUSTOMER
- Write Mode=Replace existing rows
| CUSTOMER_ID | NAME |
|---|---|
| 17 | Harbour Foods |
| CUSTOMER_ID | NAME |
|---|---|
| 17 | Harbour Foods |
Worth knowing
- Rows are array-bound in one INSERT; Upsert deletes the incoming keys first, in the same transaction.
- Snowflake folds plain names to capitals, so customer_id writes to CUSTOMER_ID.
- A running warehouse is needed; the user's default warehouse is used.