Skip to main content
Snowflake source configuration form

​
Overview

The Snowflake source synchronizes data from a Snowflake table or view into Reelevant. Use it to bring warehouse data into your personalization workflows.

​
Configuration

​
Required Fields

​
Authentication

Snowflake supports two authentication methods:
Authenticate using a username and password.

​
Optional Fields

​
Custom SQL Queries

When you provide a custom SQL query, Reelevant executes it against Snowflake instead of reading the entire table. This is useful for:
  • Filtering rows (e.g. SELECT * FROM my_table WHERE is_active = TRUE)
  • Selecting specific columns
  • Joining multiple tables
  • Applying transformations
The query must be valid Snowflake SQL. Make sure the user has the appropriate role and permissions to access the referenced tables.

​
Incremental Sync

Snowflake supports incremental synchronization when used with the Keep Previous Data update mode. When configured, Reelevant appends a WHERE clause to your query (or generates one automatically) to only fetch rows where the timestamp column is greater than the last recorded value.
The timestamp column is optional even in Keep Previous Data mode — if your Snowflake view already handles delta logic internally, you can omit it.

​
Data Type Handling

Snowflake data types are streamed with the following conversions:

​
How It Works

  1. Reelevant connects to Snowflake using the provided credentials and warehouse.
  2. If a custom query is provided, it is executed. Otherwise, SELECT * FROM <table> is run.
  3. Results are streamed row-by-row for efficient memory usage.
  4. Fields are extracted and made available for mapping.
  5. On subsequent syncs, the data is re-read (or incrementally fetched if a timestamp column is configured).
Ensure the Snowflake user has the appropriate role to access the specified warehouse, database, schema, and table.