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.

Note

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.

In this Topic:

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
Talend logo
Fivetran logo
  • Fivetran — data replication service
  • Snowflake requirements:
    • None — JDBC driver bundled with Fivetran
  • Additional reading:
SnapLogic logo
Alooma logo
  • Alooma — data integration service
  • Snowflake requirements:
    • None — JDBC driver bundled with Alooma
  • Additional reading:
Denodo logo
  • Denodo — data virtualization platform
  • 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
  • Tableau — interactive data visualization and exploration
  • Snowflake requirements:
Tableau logo
  • Looker — data exploration and reporting
  • Snowflake requirements:
    • None — JDBC driver bundled with Looker
  • Additional reading:
IBM Cognos logo
Microsoft logo
MicroStrategy logo
Mode Analytics logo
Qlik logo
Pentaho logo
Periscope logo

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
R logo
dplyr

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
Python logo

SQL Editing and Querying Tools

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

Snowflake logo
  • Worksheet — SQL editor directly integrated into the Snowflake web interface with support for multiple, independent working environments
    • No installation or configuration required
  • SnowSQL — command line interface for executing SQL statements in either batch or interactive mode
    • Download from Snowflake web interface and install using provided installer
SQL Workbench/J