Resources
FEATURED CASE STUDY
Coinbase Saves Millions, Reduces Experiment Analysis Time by 40%, and Restores Trust in Experimentation with Eppo
Learn more
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
- Ab Initio
- Agile Data Engine
- Airbyte
- Alteryx
- Amazon Data Firehose
- Artie
- Ascend.io
- Azure Data Factory
- Coalesce
- Census
- Datameer
- Data Virtuality
- dbt Labs
- Devart ODBC Driver for Snowflake
- Devart SSIS Data Flow Components for Snowflake
- Diyotta
- Etleap
- Etlworks
- Fivetran
- Google Cloud Data Fusion
- Google Cloud Dataflow
- Heap
- Hevo Data
- Hightouch
- Keboola
- Knoema
- Matillion ETL
- Minitab
- Nexla
- Precog
- Rivery
- Segment
- Skyvia
- Solace
- Snowplow
- Stitch Data
- Software AG
- Striim
- Supermetrics
- Trifacta
- WhereScape
- Workato
Tools with special requirements
To check specific requirements regarding snowflake data integration, consult here.
- Boomi
- CData Software
- Denodo
- Informatica Cloud
- Informatica PowerCenter
- Kafka
- Pentaho Data Integration (PDI)
- Qlik Replicate
- Redpoint
- SAP Data Services
- SnapLogic
- Tableau Prep
- Talend
- TIBCO ActiveMatrix BusinessWorks
Business intelligence tools
Here is a list of business intelligence tools that can connect to Snowflake:
- Adobe Campaign
- Astrato
- AtScale
- AWS QuickSight
- CARTO
- Chartio
- Domo
- Eppo
- IBM Cognos Analytics
- Looker
- MachEye
- Metabase
- Microsoft Power BI
- MicroStrategy
- Mode Analytics
- Oracle Analytics
- Pyramid Analytics
- Qlik
- Sigma Computing
- SAP BusinessObjects
- Sisense
- Tableau
- Tableau CRM
- ThoughtSpot
- TIBCO Spotfire
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:
- Alteryx
- Amazon SageMaker
- BoostKPI
- Databricks
- Dataiku
- DataRobot
- Domino
- Eppo
- H2O.ai
- Hex
- Qubole
- SAS
- Apache Spark
- Tellius
- DataRobot
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:
- Acryl Data
- Alation
- ALTR
- Anomalo
- Atlan
- Baffle
- Bigeye
- BigID
- Collibra
- Comforte
- Datadog
- data.world
- DvSum
- Fortanix
- HashiCorp Vault
- Hunters
- Immuta
- Informatica
- Lacework
- Monte Carlo
- Normalyze
- Okera
- OneTrust
- OvalEdge
- Privacera
- Protegrity
- PKWARE
- Satori Cyber
- SecuPi
- Select Star
- Skyflow
- Sled
- Spring Labs
- Tamr
- Thales
- ThoughtSpot
- Trustlogix
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
- Agile Data Engine
- Cogniti
- DataOps.live
- DBeaver
- Erwin
- Hackolade
- SeekWell
- Solita Agile Data Engine
- SqlDBM
- SQL Workbench
- Statsig
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:
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.
Table of contents
Ready to go from knowledge to action?
Talk to our team of experts and see why companies like Twitch, DraftKings, and Perplexity use Eppo to power experimentation for every team.
Get a demo
Keep reading
