Skip to main content

Snowflake

This Data Source enables you to use your Snowflake data with Propel. It provides an easy way to deploy an analytics API on top of Snowflake.

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.

NameDescriptionSync BehaviorStatus
TableA Snowflake table.Append onlyGenerally available
ViewA Snowflake view.Not supportedNot supported
Materialized viewA Snowflake materialized view.Not supportedNot supported

Table

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 DATE, DATETIME, TIMESTAMP, TIMESTAMP_LTZ, TIMESTAMP_NTZ, or TIMESTAMP_TZ column.
  • The table must have a unique identifier column.
tip

Use the TIMESTAMP_LTZ type for date time columns as it specifies the timezone.

Usage

Once you create your Snowflake Data Source, you can then create Data Pools from your Snowflake tables.

  1. Click on Data Pools on the left-hand side menu.
  2. Click on the "New Data Pool" button.
  3. Select a name and description for your Data Pool.
  4. Select your Snowflake Data Source.
  5. Select the Snowflake table you want to use.
  6. Click the "Create" button.

After you create your Data Pool, you can define Metrics with your Data Pool's data.

An animated screen capture of of how to use a Snowflake Data Source to create a Data Pool.

Propel's guides to Snowflake as a Data Source

API reference documentation

Below is the relevant API documentation for the Snowflake Data Source.

Objects

Enums

Inputs

Queries

Mutations

Limits

No limits at this point.