Skip to main content
The Snowflake integration allows Email Meter to push enriched email analytics data directly to your own Snowflake instance. This enables you to combine your email statistics with other business data in your data warehouse. The Snowflake integration transfers data to a database that you own and control. This gives you full ownership of the data and the flexibility to transform, combine, and query it alongside your other datasets. Email Meter handles the data synchronization process, ensuring your Snowflake instance receives regular updates with the latest email metrics and analytics.

​
Requirements

Before you can set up the Snowflake integration, please make sure that you meet the requirements below:
  • A Snowflake account with administrative access
  • A dedicated database for Email Meter data
  • A Snowflake user with permissions to create schemas in the target database
  • A Snowflake warehouse for data loading operations

​
Instructions

To set up the integration, you’ll need to create a dedicated user and configure the appropriate permissions in your Snowflake account. Follow these steps:
1

Create a database

Log in to your Snowflake account and create a dedicated database for Email Meter data:
CREATE DATABASE IF NOT EXISTS EMAILMETER;
You can customize the database name according to your naming conventions.
2

Create a warehouse

Create a warehouse that will be used for data loading operations:
CREATE WAREHOUSE IF NOT EXISTS EMAILMETER_WH
  WAREHOUSE_SIZE = 'XSMALL'
  AUTO_SUSPEND = 60
  AUTO_RESUME = TRUE;
The warehouse size can be adjusted based on your data volume. An X-Small warehouse is typically sufficient for most use cases.
3

Create a dedicated user and role

Create a dedicated role and user for the Email Meter integration:
CREATE ROLE IF NOT EXISTS EMAILMETER_ROLE;
CREATE USER IF NOT EXISTS EMAILMETER_USER
  DEFAULT_ROLE = EMAILMETER_ROLE
  DEFAULT_WAREHOUSE = EMAILMETER_WH;
4

Generate a key pair

Generate a private and public key pair for authentication. Run these commands in your terminal:
# Generate encrypted private key
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -v2 aes-256-cbc -out snowflake_emailmeter_key.p8

# Generate public key
openssl rsa -in snowflake_emailmeter_key.p8 -pubout -out snowflake_emailmeter_key.pub
You will be prompted to create a passphrase for the private key. Make sure to save this passphrase securely.
5

Assign the public key to the user

Extract the public key value (without the header/footer lines) and assign it to the user:
ALTER USER EMAILMETER_USER SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...your_public_key_here...';
The public key value is the content of the .pub file without the -----BEGIN PUBLIC KEY----- and -----END PUBLIC KEY----- lines.
6

Grant permissions

Grant the necessary permissions to the role:
GRANT USAGE ON WAREHOUSE EMAILMETER_WH TO ROLE EMAILMETER_ROLE;
GRANT USAGE ON DATABASE EMAILMETER TO ROLE EMAILMETER_ROLE;
GRANT CREATE SCHEMA ON DATABASE EMAILMETER TO ROLE EMAILMETER_ROLE;
GRANT ROLE EMAILMETER_ROLE TO USER EMAILMETER_USER;
7

Share credentials with Email Meter

Once the previous steps are completed, please share the following information with your Project Manager or Business Intelligence Consultant:
  • Host: Your Snowflake host URL (e.g., xy12345.us-east-1.aws.snowflakecomputing.com)
  • Role: The role name (e.g., EMAILMETER_ROLE)
  • Warehouse: The warehouse name (e.g., EMAILMETER_WH)
  • Database: The database name (e.g., EMAILMETER)
  • Username: The user name (e.g., EMAILMETER_USER)
  • Private key: The private key file (snowflake_emailmeter_key.p8)
  • Private key passphrase: The passphrase used to encrypt the private key
You can find your Snowflake host URL in your browser’s address bar when logged into Snowflake. It follows the format account-identifier.region.cloud.snowflakecomputing.com (e.g., xy12345.us-east-1.aws.snowflakecomputing.com).

​
Integrate Snowflake with other tools

Once your email analytics data is in Snowflake, you can easily connect it to your favorite Business Intelligence tools. Here are some popular integrations:

​
Frequently asked questions

Data synchronization frequency depends on your specific requirements. We typically offer daily synchronization, but more frequent updates can be configured based on your needs. Please discuss your requirements with your Business Intelligence Consultant.
We support all Snowflake cloud regions across AWS, Azure, and Google Cloud. Your data will be transferred to whichever region hosts your Snowflake account.
Yes, you can use an existing database. Just make sure the dedicated role has the appropriate permissions to create schemas in the target database.
As our email analytics product is customized to your needs, each client’s schema might be a bit different. Please get in touch with your Business Intelligence Consultant to request your own schema documentation.
Key pair authentication provides enhanced security compared to username/password authentication. It uses RSA key pairs, which are more resistant to brute-force attacks and don’t require storing passwords. This is the industry-recommended approach for production environments and automated integrations.