Skip to main content

Snowflake

The Snowflake connection lets FunnelStory query your warehouse with read-only access so you can build data models on curated tables and views—common for ARR, account dimensions, and historical metrics.

What FunnelStory uses it for​

  • Data models — Standard SQL against Snowflake; ideal for large datasets and role-based access you already manage in Snowflake.

Before you connect​

Create a dedicated user and role with least privilege:

  1. Role — Create a role (for example FUNNELSTORY_ROLE), grant USAGE on the warehouse FunnelStory will use, and grant the role to your user.
  2. User — Create a user with DEFAULT_ROLE set to that role.
  3. Database/schema — GRANT USAGE on the database and schema, then GRANT SELECT ON ALL TABLES / VIEWS in that schema, plus FUTURE grants if you want new objects included automatically.

Snowflake supports password or RSA key pair authentication. For key pair auth, register the public key on the user (ALTER USER … SET RSA_PUBLIC_KEY='…'), base64-encode the private key, and paste it (with optional passphrase) into the FunnelStory form when the UI requests it. See Snowflake key-pair documentation for key generation details.

Add the connection in FunnelStory​

  1. Open Configuration → Connections → Add connection, then choose Snowflake.

  2. Complete the fields in the connection form:

Snowflake connection form

FieldDescription
Connection nameDisplay name.
AccountSnowflake account identifier (as in the Snowflake URL).
UsernameSnowflake user.
PasswordPassword (omit if using private key only).
DatabaseDefault database.
WarehouseWarehouse to run queries.
Schema (optional)Default schema.
Role (optional)Role to assume.
Region (optional)If your account requires an explicit region.
Private key (Base64) / Passphrase (optional)For RSA authentication when enabled.
  1. Click Validate, then Add Connection.

After you connect​

Use Snowflake SQL in models. See Writing queries for value types and timestamps.