ETL: Snowflake Source

Configure the Snowflake source component to read data from Snowflake tables and views in your Integrate.io ETL data pipeline for processing.

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 locator (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

1. Select an existing Snowflake connection or create a new one.
2. Choose the source type: Table or Query.
3. For Table mode: select the schema and table.
4. For Query mode: write a custom SQL query.
5. 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.