Products

Experimentation

Learn more

Feature Flagging

Learn more

Key features

Warehouse Native

Artificial Intelligence

RESOURCES

FEATURED CASE STUDY

Turning AI hype into tangible business value through experimentation

Learn more

Blog

Tips

July 24, 2024

Snowflake integrations: All the tools you can connect

Discover why Snowflake integration is vital. Learn how to integrate with a plethora of tools to simplify your data workflows and impact your bottom line.

Ryan Lucht

Before joining Eppo, Ryan spent 6 years in the experimentation space consulting for companies like Clorox, Braintree, Yami, and DoorDash.

Snowflake is a cloud-based data platform (the “AI data cloud”) that can integrate with a wide array of modern business tools.

Let’s take a look at all the different types of Snowflake integrations there are — and there’s a lot!

We'll cover:

Data integration tools: These tools allow you to move data into and out of Snowflake from a variety of sources, including databases, files, and applications.
Business intelligence tools: These tools help you visualize and analyze your data so that you can make better business decisions.
Machine learning and data science tools: These tools let you build and deploy machine learning models and data science workflows on Snowflake.
Security and governance tools: These tools help you protect your data and ensure that it is used in a compliant manner.
SQL development and management tools: These tools help you develop and manage your SQL queries and databases on Snowflake.
Native programmatic tools: These tools allow you to interact with Snowflake using a variety of programming languages.

‍

Data integration tools

To make it easy for you, we've divided this section into tools that work right out of the box with Snowflake, and others that require just a bit more attention to detail to get them up and running.

‍

Tools with no special requirements

‍

Tools with special requirements

To check specific requirements regarding snowflake data integration, consult here.

‍

Business intelligence tools

Here is a list of business intelligence tools that can connect to Snowflake:

For any extra details regarding installation requirements, consult here.

‍

Machine learning and data science tools

Here is a list of machine learning and data science tools that can connect to Snowflake:

For more information about how to install and use these tools with Snowflake, follow this link.

‍

Security and governance tools

Here is a list of security and governance tools that can connect to Snowflake:

For more information about how to install and use these tools with Snowflake, go here.

‍

SQL development and management tools

Here is a list of SQL development and management tools that offer Snowflake integration:

Snowflake's native development interfaces

Snowsight Worksheets: Browser-based SQL development and editing
SnowSQL: Python-based client for querying and managing data in Snowflake

‍

Third-party tools

For more information about installation requirements, check here.

‍

Native programmatic interfaces

Lastly, here’s a list of native programmatic interfaces that offer Snowflake integration too:

‍

How to integrate Snowflake with Eppo

Eppo is an experimentation platform designed to help companies make smarter decisions based on data. It natively integrates with your Snowflake data warehouse, allowing you to run experiments, analyze results, and uncover insights that can drive growth.

By connecting Eppo to Snowflake, you can leverage the power of your data to test hypotheses, measure impact, and confidently make informed choices that impact key business metrics, such as retention and revenue margins.

Here’s how to integrate Snowflake with Eppo, including how to create a service user and schema in Snowflake, and how to configure the credentials in Eppo. Let’s kick things off with the first step:

1. Setting up Snowflake

1.1 Create a Service User for Eppo

Log in to Snowflake with a user that has ACCOUNTADMIN privileges.
Create a new user with the following command (replace placeholders with your desired values):

CREATE USER <user_name> PASSWORD = '<password>'

Note: If you prefer to use key-pair authentication, consult Eppo’s documentation for specific instructions.

Create a role (replace <role_name>):

CREATE ROLE <role_name>;

Grant the necessary privileges to the role (replace <db_name>, <schema_name>, and <role_name> accordingly):

GRANT USAGE ON DATABASE <db_name> TO ROLE <role_name>;

GRANT USAGE ON SCHEMA <db_name>.<schema_name> TO ROLE <role_name>;

GRANT SELECT ON ALL TABLES IN SCHEMA <db_name>.<schema_name> TO ROLE <role_name>;

Assign the role to the new user:

GRANT ROLE <role_name> TO USER <user_name>;

‍

1.2 Create a schema for Eppo

Execute the following command in Snowflake to create a schema where Eppo can store its results (replace <schema_name>):

CREATE SCHEMA IF NOT EXISTS <schema_name>;

‍

1.3 (Optional) Create a warehouse for Eppo

If you have a dedicated warehouse for Eppo's operations, create it using standard Snowflake commands.

‍

2. Configuring Eppo

2.1 Log into Eppo

Access your Eppo account at eppo.cloud

‍

2.2 Navigate to Warehouse connection

Click the "Getting Started" button in the top-right corner.
In the "Connect your Warehouse" tab, click "Connect your data warehouse to Eppo."
On the data warehouse connection screen, click the "Snowflake" tab.

‍

2.3 Enter Snowflake credentials

Fill in the required fields:some text
- Server: Your Snowflake account identifier (e.g., xy12345.snowflakecomputing.com)
- Warehouse: The name of the warehouse (if applicable)
- Database: The name of your Snowflake database
- Schema: The schema you created for Eppo
- Username: The username of the service user you created in Snowflake
- Role: The role associated with the service user
- Password or key pair: Enter the password or upload your key pair, depending on the authentication method you chose.

‍

2.4 Test connection

Click "Test Connection" to ensure the credentials are valid and Eppo can access your Snowflake instance.

‍

Next steps

Now you know about Snowflake integration with a wide array of tools and how to integrate Eppo too.

For more on how Eppo can help you discover key business insights, read more here.

If you want to test Eppo yourself:

Book a Demo and Explore Eppo.

Discover why Snowflake integration is vital. Learn how to integrate with a plethora of tools to simplify your data workflows and impact your bottom line.

‍

No Headings

no headings