Input
Snowflake Input
Reads a whole table or view from Snowflake and turns it into rows.
When to use it
Use it for warehouse data kept in Snowflake: fact and dimension tables, prepared views.
In a pipeline
Snowflake InputSummarize (Multi-Aggregate)Export Excel
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Table | select | Yes | Select a table |
Example
Warehouse extract
- Table=PUBLIC.FCT_ORDERS
| ORDER_ID | TOTAL |
|---|---|
| 1042 | 860 |
| 1043 | 312.5 |
Worth knowing
- The connection's Account is the account identifier (xy12345.eu-west-1 or myorg-myaccount); the user's default warehouse and role are used.
- Tables are listed as SCHEMA.TABLE from the connection's database.
- Big result? Put the filter into a view in Snowflake and read the view.