Snowflake Warehouse Connector

​

Connect Snowflake

• Your Snowflake account identifier, which you can find in the URL of your Snowflake account (https://YOUR_ACCOUNT_NAME.snowflakecomputing.com/).
• A dedicated Mixpanel user account and role. The user account can use either key-pair or password authentication. If using key-pair authentication, Mixpanel will generate a secure key-pair during the connection process. The public key will be provided during the setup process, and the private key will be encrypted and stored securely.
  CREATE ROLE MIXPANEL_ROLE;
  -- one of
  CREATE USER MIXPANEL PASSWORD='?????' DEFAULT_ROLE=MIXPANEL_ROLE;
  CREATE USER MIXPANEL RSA_PUBLIC_KEY='<mixpanel-provided-key>' DEFAULT_ROLE=MIXPANEL_ROLE;
  -- then
  GRANT ROLE MIXPANEL_ROLE TO USER MIXPANEL;
  
• A Snowflake WAREHOUSE Mixpanel will use to unload data. We recommend creating a dedicated warehouse for Mixpanel to avoid impacting other workloads.
  CREATE WAREHOUSE MIXPANEL_WAREHOUSE WITH
    WAREHOUSE_SIZE = XSMALL -- consider increasing for larger datasets
    AUTO_SUSPEND = 60
    AUTO_RESUME = TRUE
    INITIALLY_SUSPENDED = TRUE;
  GRANT USAGE ON WAREHOUSE MIXPANEL_WAREHOUSE TO ROLE MIXPANEL_ROLE;
  GRANT MONITOR ON WAREHOUSE MIXPANEL_WAREHOUSE TO ROLE MIXPANEL_ROLE;
  
• A Snowflake STORAGE INTEGRATION Mixpanel will use to unload data. This integration can optionally restrict STORAGE_ALLOWED_LOCATIONS to the unique Mixpanel-managed bucket created to receive data for this connection.
  CREATE STORAGE INTEGRATION MIXPANEL_STORAGE_INTEGRATION
    TYPE = EXTERNAL_STAGE
    STORAGE_PROVIDER = 'GCS'
    ENABLED = TRUE
    STORAGE_ALLOWED_LOCATIONS = ("<mixpanel-provided-bucket-name>"); -- optional
  GRANT USAGE ON INTEGRATION MIXPANEL_STORAGE_INTEGRATION TO ROLE MIXPANEL_ROLE;
  
• A new, empty MIXPANEL SCHEMA the Mixpanel user has the USAGE and CREATE STREAM permission for (if you are using Mirror).
  CREATE SCHEMA <database>.MIXPANEL;
  GRANT USAGE ON DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT USAGE ON SCHEMA <database>.MIXPANEL TO ROLE MIXPANEL_ROLE;
  GRANT CREATE STREAM ON SCHEMA <database>.MIXPANEL TO ROLE MIXPANEL_ROLE;
  
• The Mixpanel user needs the USAGE and SELECT permissions to have read-only access to any tables and views you plan to sync. Adjust this example to fine-tune permissions.
  GRANT USAGE ON DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT USAGE ON ALL SCHEMAS IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT USAGE ON FUTURE SCHEMAS IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT SELECT ON ALL TABLES IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT SELECT ON FUTURE TABLES IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT SELECT ON ALL VIEWS IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT SELECT ON FUTURE VIEWS IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT SELECT ON ALL MATERIALIZED VIEWS IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  GRANT SELECT ON FUTURE MATERIALIZED VIEWS IN DATABASE <database> TO ROLE MIXPANEL_ROLE;
  

​

IP Allowlist

34.31.112.201
35.184.21.33
35.225.176.74

34.147.68.192
35.204.164.122
35.204.177.251

34.47.224.29
34.93.42.83
35.244.19.238

• Some users report seeing the following error ErrorMessage=SQL compilation error: Cannot unload to an inlined external location. Please create a stage first and unload to the stage instead.. To resolve this error, you may set the following account security setting:

ALTER ACCOUNT SET PREVENT_UNLOAD_TO_INLINE_URL = FALSE;

​

Mirror Mode

ALTER TABLE <table> SET CHANGE_TRACKING = TRUE;
# or
ALTER VIEW <view> SET CHANGE_TRACKING = TRUE;

• Snowflake Streams only maintain change tracking metadata for a limited number of days determined by the larger of DATA_RETENTION_TIME_IN_DAYS and MAX_DATA_EXTENSION_TIME_IN_DAYS (default is 14 days for MAX_DATA_EXTENSION_TIME_IN_DAYS). Make sure that the Mixpanel sync does not go longer than this number of days without running. Mixpanel recommends leaving the default of 14 days to ensure that if Mixpanel loses access to the warehouse unexpectedly (e.g., a credentials change), there is time to correct the issue.
• Snowflake Streams do not work if a table is deleted and re-created with the same name. If using a tool like DBT to model data in Snowflake, make sure to use an incremental model so that DBT does not replace the table each time it runs.
• Snowflake streams don’t capture changes when a column is deleted or renamed, so deletion of columns won’t be synced to Mixpanel.
• Snowflake has specific requirements when using Streams on Views that must be met when using Mirror with views.
• While Snowflake Streams are a very efficient way of tracking changes, there are some performance implications when using Streams on VIEWs that contain JOINs. If you find yourself needing such a JOIN in event data, we recommend considering if syncing the joined data as User Profiles, Group Profiles, or a Lookup Table would work instead.

ALTER TABLE <table> ADD COLUMN <column> VARCHAR DEFAULT NULL;