​

Introduction

​

MoEngage × Snowflake

​

Benefits

​

Reduce integration time

• No more searching for the right ETL tool, as MoEngage directly integrates with Snowflake.
• Long and complicated ETL pipelines are now replaced with a one-time integration setup that gives MoEngage direct access to your data without actual data flow.
• This decreases the dependency on tech teams significantly.

​

Faster data processing

• The power of the Snowflake infrastructure enables us to store, process, and query massive amounts of data in near real-time.
• Any changes in the original schema are propagated immediately without having to change any configuration on MoEngage’s end, which is a significant advantage over the traditional ETL pipelines.
• Since there is no need for ETL tools and external cloud providers, the cost of import is significantly lower than traditional data pipelines.

​

Integration use-cases

• Sync real-time audiences from Snowflake
• Keep your users in MoEngage up-to-date with the user data in your Snowflake account.
• Import event data from your Snowflake account directly into MoEngage.
• Import users into MoEngage and retarget them via custom segments.

​

Integration

​

Set up a new Snowflake Connection

1. On your MoEngage Dashboard, go to the App Marketplace.
2. Search for “Snowflake”.
3. Go to the Integrate tab, and click + Add Connection.
4. Provide your Snowflake data warehouse details:

   Field	Description	Example
   Connection Name	Give this connection an identifiable name.	My Snowflake Prod
   Snowflake Account Identifier	The account identifier of your Snowflake account. It is always found at the beginning of your Snowflake URL (https://ACCOUNT_IDENTIFIER.snowflakecomputing.com). The format may differ based on Snowflake account age. For details, visit Snowflake docs. If you’re using Snowsight, you can click on your account name at the bottom of the left nav. Select the account you want to import from and then click on the “copy” icon to copy the Account Identifier. For up-to-date information, you can visit Snowflake docs.	Format should be: ACCOUNT_IDENTIFIER.snowflakecomputing.com
   Warehouse	The name of the warehouse MoEngage will use to execute the queries.	COMPUTE_WAREHOUSE
   Database	The database that MoEngage should use to read the tables from. You can pick the schema while setting up imports/exports.	MY_DEMO_DB
   Username	Either an existing database username with the read access or create a new one for MoEngage.	—
   Authentication Method	MoEngage can connect to your Snowflake Instance using two methods: Password - Please provide the password of the database user (username) you entered above. Key - MoEngage can connect to your Snowflake Instance using the Key pair authentication method.	—
   Role	This role will be used in executing queries from MoEngage. You can click Test connection to test your details or directly click on Save connection to proceed.	—
   For Key pair authentication:

   1. Select Key as your authentication method.
   2. Click on Generate Key and MoEngage will display your public key. You will need to add this public key to your database user. Follow the instructions mentioned on Snowflake help docs to set this up:
   3. Once you have added this key to your database user, click on Test connection and MoEngage will attempt to verify the credentials. MoEngage also supports rotating of keys. If your IT Policy requires key rotation, you can do it by following these steps:
   4. Go to the App Marketplace > Snowflake > Integrate and edit the connection.
   5. Click on the generate new key icon:
   6. A confirmation will be asked for you to review. Please read the instructions carefully. Once you save the connection with the newly generated key, MoEngage will no longer use the previous key. You have to ensure that the new key is attached to your database user as the second RSA key (see Snowflake help doc on rotating keys) for the rotation to work properly. If the new key is not attached after saving the connection, your imports and exports might break:
   7. Your new key will be generated and shown to you. At this point, it is highly recommended to copy this new key and attach it as an additional key to your Snowflake database user by following the instructions provided on the Snowflake help docs. Once you have attached the new key, you need to test the connection successfully to complete the rotation.
   8. At any point after generating the new key, if you decide to close the edit form, or do not click on Connect, your old (existing) key will continue to be used as before and the newly generated key will be deleted from our system.
5. Once you have set up a Snowflake Connection, you can use that to set up various imports and exports in MoEngage.

​

Supported Datetime Formats

​

Warehouse Segments Using Snowflake

​

Import users and events from Snowflake into MoEngage

​

Export events from MoEngage to Snowflake

​

Step 1: Make sure your user’s assigned role has required permissions

-- Create a role for the MoEngage user
CREATE ROLE MOENGAGE_ROLE;
-- Allow the user to run queries in the warehouse
GRANT USAGE ON WAREHOUSE <YOUR_WAREHOUSE_NAME> TO ROLE MOENGAGE_ROLE;
-- Let the user see this database
GRANT USAGE ON DATABASE <YOUR_DATABASE_NAME> TO ROLE MOENGAGE_ROLE;
-- Let the user see all schemas in this database
GRANT USAGE ON SCHEMA <YOUR_DATABASE_NAME>.<YOUR_SCHEMA_NAME> TO ROLE MOENGAGE_ROLE;
-- Let the user create a table in your schema
GRANT CREATE TABLE ON SCHEMA <YOUR_DATABASE_NAME>.<YOUR_SCHEMA_NAME> TO ROLE MOENGAGE_ROLE;
-- Let the user insert data in your tables
GRANT INSERT, SELECT ON ALL TABLES IN SCHEMA <YOUR_DATABASE_NAME>.<YOUR_SCHEMA_NAME> TO ROLE MOENGAGE_ROLE;

-- Create the MoEngage user (MOENGAGE_USER is username here)
CREATE USER MOENGAGE_USER WITH DEFAULT_ROLE = MOENGAGE_ROLE DEFAULT_WAREHOUSE = <YOUR_WAREHOUSE_NAME> PASSWORD = '<YOUR_PASSWORD>';
-- Grant the role to the user
GRANT ROLE MOENGAGE_ROLE TO USER MOENGAGE_USER;

1. <YOUR_WAREHOUSE_NAME> - The name of the warehouse you want MoEngage to use while executing queries.
2. <YOUR_DATABASE_NAME> - The name of the database you want to import data from.
3. <YOUR_PASSWORD> - Give a strong password to the newly created database user.

​

Step 2: Create a new export in the App Marketplace

1. Click Integrate > Add Integration.
2. Select your Snowflake connection.
3. Select which schema MoEngage will use to create new tables and export your events into.
4. Select the events and additional user properties you want to export to Snowflake.
5. Click Save Export.

​

Export Process and Frequency

• Initial action: MoEngage creates the table when the first export is triggered.
• Recurring action: MoEngage adds (appends) data to the same table every hour.

​

Sample Table Structure

​

Export Frequency

​

Frequently Asked Questions