Overview of the Ecosystem

Snowflake works with a broad array of industry-leading tools and technologies. From ETL to business intelligence and advanced analytics, our native solutions, partnerships, and other integrations enable you to leverage Snowflake to quickly and easily deliver insights into your data.

This topic lists a number of different options for connecting to Snowflake:

  • Snowflake-provided client software (SnowSQL, Python connector, Node.js driver, JDBC driver, ODBC driver, etc.)
  • Partners with whom we have jointly implemented connectors using our JDBC and ODBC drivers.
  • Providers who have independently developed solutions for connecting to Snowflake.
  • Other tools and technologies that are known to work with Snowflake.

The options are organized into categories based on usage/type.

In this Topic:


If you need to connect to Snowflake using a tool or technology that is not listed here, we suggest first attempting to connect through our JDBC or ODBC drivers. These drivers provide general, multi-purpose connection functionality for most tools and technologies that support JDBC or ODBC.

In addition, you are not limited to working with the vendors/solutions listed here. Other solutions can be used with Snowflake; however, we cannot guarantee that all features provided by these solutions are supported and will operate without issue.

Data Integration and Management

Data integration and management tools perform a wide array of functions, including, but not limited to:

  • Extract — exporting data from specified data sources.
  • Transform — modifying the source data (as needed), using rules, merges, lookup tables or other conversion methods, to match the target.
  • Load — importing the resulting transformed data into a target database.

Snowflake works with the following data integration and management tools:

Informatica logo Enterprise data integration and management

Informatica Cloud:

  • Informatica requirements:
    • Informatica Secure Gateway — download and install from the Informatica Cloud interface
    • Informatica Cloud Connector for Snowflake — available directly in the Informatica Cloud interface
  • Snowflake requirements: None — JDBC driver bundled with the Informatica Cloud Connector
  • Additional reading:

Informatica PowerCenter:

Talend logo Open source data integration and management

Talend 6.4 (or later):

Earlier versions of Talend:

  • Talend requirements:
  • Snowflake requirements: None — JDBC driver bundled with Talend
Fivetran logo Data replication service
  • Fivetran requirements: None
  • Snowflake requirements: None — JDBC driver bundled with Fivetran
  • Additional reading:
SnapLogic logo Enterprise integration platform
Alooma logo Data integration service
  • Alooma requirements: None
  • Snowflake Requirements: None — JDBC driver bundled with Alooma
  • Additional reading:
Denodo logo Data virtualization platform
  • Denodo requirements: None
  • Snowflake Requirements: None — JDBC driver bundled with Denodo
  • Additional reading:

Business Intelligence

Business intelligence (BI) tools enable analyzing, transforming, and reporting data to help executives and managers make more informed business decisions.

Snowflake works with the following BI tools:

Tableau logo Interactive data visualization and exploration
  • Tableau requirements: None
  • Snowflake requirements:
Tableau logo Data exploration and reporting
  • Looker requirements: None
  • Snowflake requirements: None — JDBC driver bundled with Looker
  • Additional reading:
IBM Cognos logo Enterprise BI platform
Microsoft logo Business analytics suite

Power BI Desktop:

Power BI Cloud Service:

MicroStrategy logo Enterprise analytics platform
Mode Analytics logo SQL editor, Python development tool, and report builder
Qlik logo Desktop analytics and reporting
Pentaho logo Data integration and analytics
Periscope logo SQL editor and data visualization

Advanced Analytics

Advanced analytics covers a broad category of vendors, tools, and technologies that provide advanced capabilities for statistical and predictive modeling. While these tools and technologies often share some overlapping features and functionality with BI tools, they focus less on analyzing and reporting on past data. Instead, they focus more on examining large data sets to discover patterns and uncover useful business information that can be used to predict future trends.

Snowflake works with the following advanced analytic platforms and technologies:

Apache Spark logo Open source cluster computing framework
R logo Statistical computing and graphics environment and language
dplyr R package for interacting with external databases

Programmatic Interfaces

In addition to the partners and solutions listed above, the Snowflake ecosystem supports developing applications using popular programming languages and development platforms.

Snowflake provides native integration with the following languages and platforms:

Python logo Programming language
Python logo Open source JavaScript runtime environment

SQL Editing and Querying Tools

Snowflake provides native SQL editing and querying solutions and also works with other generic SQL editors:

Snowflake logo


  • SQL editor directly integrated into the Snowflake web interface with support for multiple, independent working environments
  • No installation or configuration required


  • SQL editor directly integrated into the Snowflake web interface with support for multiple, independent working environments
  • Download from Snowflake web interface and install using provided installer
SQL Workbench/J Cross-platform SQL query tool