Use the Snowflake source component to read data from Snowflake tables and views in your ETL pipeline.
Connection Setup
To create a Snowflake connection, you need:
- Account identifier (e.g., xy12345.us-east-1)
- Warehouse name
- Database name
- Schema name
- Username and password (or key pair authentication)
- Role (optional)
Create the connection in Integrate.io ETL: click Connections > New Connection > Snowflake, enter your credentials, and test the connection.
Source Configuration
Select an existing Snowflake connection or create a new one.
Choose the source type: Table or Query.
For Table mode: select the schema and table.
For Query mode: write a custom SQL query.
Configure field selection in the Source Schema tab.
Options
- Warehouse: Specify which Snowflake warehouse to use for the query.
- Role: Override the default role for this component.
- Query timeout: Set a maximum execution time.
Last modified on April 20, 2026
