This Data Source enables you to use your Snowflake data with Propel.
With the Snowflake Data Source, you can use any table to power your Data Pools and Metrics. Propel connects to the specified database and schema using a provided role, warehouse, and user. You can apply the least-privilege principle only to expose the necessary tables and columns. We recommend creating a dedicated role, user, and warehouse for Propel.
Set up guide
Follow our step-by-step Snowflake setup guide to connect your Snowflake data warehouse with Propel.
Supported Sync behaviors
- Append only: Syncs new records. It ignore updates or deletes. Append is suitable for inmutable event data.
Supported data stuctures
Below are the Snowflake data structures that Propel supports.
|Table||A Snowflake table.||Append only||Generally available|
|View||A Snowflake view.||Not supported||Not supported|
|Materialized view||A Snowflake materialized view.||Not supported||Not supported|
To use the table as a Data Source it must meet the following requirements:
- The table must be an append-only table, which means only new records will be synced. Updated or deleted records will be ignored. Typically tables containing event logs, audit logs, or other analytical data that is not expected to change.
- The table must have change tracking enabled. Follow this guide to enable change tracking on a Snowflake table.
- The table must have at least one
- The table must have a unique identifier column.
TIMESTAMP_LTZ type for date time columns as it specifies the timezone.
Once you create your Snowflake Data Source, you can then create Data Pools from your Snowflake tables.
- Click on Data Pools on the left-hand side menu.
- Click on the "New Data Pool" button.
- Select a name and description for your Data Pool.
- Select your Snowflake Data Source.
- Select the Snowflake table you want to use.
- Click the "Create" button.
After you create your Data Pool, you can define Metrics with your Data Pool's data.
Propel's guides to Snowflake as a Data Source
API reference documentation
Below is the relevant API documentation for the Snowflake Data Source.
- Snowflake Connection Settings Input
- Partial Snowflake Connection Settings Input
- Create Snowflake Data Source Input
- Modify Snowflake Data Source Input
- Create Snowflake Data Source
- Modify Snowflake Data Source
- Delete Data Source by ID
- Delete Data Source by unique name
No limits at this point.