Snowflake

Sync people and traits from Snowflake into Argon, and send profile data back. Our datasets are on Snowflake Marketplace too.

Screens

Data sources / SnowflakeConnected
TableANALYTICS.PUBLIC.CUSTOMERS
Identify people byuser_id→User ID
Traitsplancompanylifetime_valuelast_order_at
Schedule[SCHEDULE OPTIONS]
Recent runs[N] total
[DATE], [TIME][N] profiles changedSucceeded
[DATE], [TIME][N] profiles changedSucceeded
[DATE], [TIME][N] profiles changedSucceeded
[DATE], [TIME][N] profiles changedSucceeded

About this integration

You can use Snowflake with Zym Labs in 3 ways. Argon, our customer data and messaging suite, reads people and traits from your tables on a schedule. It can also write profile data back. And our datasets, Zym Labs Data, are listed on Snowflake Marketplace.

  • Build segments on warehouse columns like plan or lifetime value, without SQL
  • Start a journey when a synced trait moves someone into a segment
  • Keep a copy of profile data in Snowflake for analysis, with Sync
  • Query sanctions, economic and holiday data next to your own tables

In Argon

3 Argon modules use your Snowflake data.

In Zym Labs Data

Our datasets are on Snowflake Marketplace. When you get one, it appears as shared tables in your account, next to your own data.

  1. Create a role

    Create a Snowflake role and user for Argon, with read access to the tables it syncs.

  2. Add the connection

    In Argon, open Data sources, choose Snowflake and enter your account details.

  3. Pick tables

    Choose a table or view, the column that identifies each person and the columns to keep as traits.

  4. Set the schedule

    Choose how often Argon reads the table: [SCHEDULE OPTIONS].

SQL
CREATE ROLE ARGON_SYNC;
GRANT USAGE ON WAREHOUSE ARGON_WH TO ROLE ARGON_SYNC;
GRANT USAGE ON DATABASE ANALYTICS TO ROLE ARGON_SYNC;
GRANT USAGE ON SCHEMA ANALYTICS.PUBLIC TO ROLE ARGON_SYNC;
GRANT SELECT ON ALL TABLES IN SCHEMA ANALYTICS.PUBLIC TO ROLE ARGON_SYNC;
-- [ANY OTHER PRIVILEGES ARGON NEEDS]

Changelog

[DATE] · First release. People and traits from Snowflake into Profiles, on a schedule.