Data Integration

Commonly referred to as ETL, data integration encompasses the following three primary operations:

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.

The more recent usage of the term is ELT, emphasizing that the transformation operation does not necessarily need to be performed before loading, particularly in systems such as Snowflake that support transformation during or after loading.

In addition, the scope of data integration has expanded to include a wider range of operations, including:

  • Data preparation.

  • Data migration, movement, and management.

  • Data warehouse automation.

The following data integration tools and technologies are known to provide native connectivity to Snowflake:

Solution

Version / Installation Requirements

Notes

Ab Initio

Ab Initio: No requirements — contact Ab Initio for more details

Snowflake: ODBC Driver — download from the ODBC Download page

Agile Data Engine

Agile Data Engine: No requirements

Snowflake: No requirements

Airbyte

Airbyte: No requirements

Snowflake: No requirements

Alteryx

Available in Partner Connect

Alteryx Designer Cloud: No requirements

Snowflake: No requirements

Amazon Data Firehose

Amazon Data Firehose: No requirements

Snowflake: No requirements

Additional resources:

Ascend.io

Available in Partner Connect

Ascend.io: No requirements

Snowflake: No requirements

Azure Data Factory

Azure Data Factory: No requirements

Snowflake: No requirements

Boomi

Boomi: DCP 4.2 (or higher) or Integration July 2020 (or higher)

Snowflake: No requirements

Coalesce

Available in Partner Connect

Coalesce: No requirements

Snowflake: No requirements

CData Software

CData Software: The latest version of the driver/connector/application is always recommended, but legacy versions will continue to work if they are licensed.

Note that any changes to Snowflake since the release of a driver may not be available in the driver depending on how the changes are implemented.

Snowflake: No requirements

Census

Available in Partner Connect

Census: No requirements

Snowflake: No requirements

Datameer

Datameer: v7

Snowflake: No requirements

DataVirtuality

DataVirtuality: No requirements

Snowflake: No requirements

dbt Labs

Available in Partner Connect

dbt: v0.13 (or higher)

Snowflake: No requirements

Denodo

Denodo: Denodo Platform 6.0 (or higher)

Snowflake: No requirements

Diyotta

Diyotta: No requirements

Snowflake: No requirements

Etleap

Available in Partner Connect

Etleap: No requirements

Snowflake: No requirements

Etlworks

Etlworks: No requirements

Snowflake: No requirements

Fivetran

Available in Partner Connect

Fivetran: No requirements

Snowflake: No requirements

Google Cloud Data Fusion

Google Cloud Data Fusion: Snowflake plugin

Snowflake: No requirements

Google Cloud Dataflow

Google Cloud Dataflow: Apache Beam

Snowflake: No requirements

Heap

Heap: Connect

Snowflake: No requirements

Hevo Data

Hevo Data: No requirements

Snowflake: No requirements

Hightouch

Available in Partner Connect

Hightouch: No requirements

Snowflake: No requirements

HVR

HVR: No requirements

Snowflake: ODBC Driver — download from the ODBC Download page

IBM InfoSphere DataStage

DataStage: InfoSphere Information Server 11.7

Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository

Informatica

Available in Partner Connect

Informatica Cloud:

  • Cloud Connector for Snowflake — available directly in the Informatica Cloud interface or by download from the Informatica Marketplace.

  • Secure Agent — download and install from the Informatica Cloud interface

Snowflake:

  • For push-down optimization: ODBC Driver — download from the ODBC Download page

  • For all other functionality: No requirements

Informatica

Available in Partner Connect

Informatica Data Loader: No requirements

Snowflake: No requirements

Informatica

Informatica PowerCenter:

  • PowerCenter 10.2 (or higher)

  • PowerExchange for Snowflake

Snowflake:

  • For push-down optimization: ODBC Driver — download from the ODBC Download page

  • For all other functionality: No requirements

Apache Kafka

Apache Kafka: No requirements

Kafka Connect: API 2.0.0 to 2.2.0 (all other versions are not supported)

Snowflake: Snowflake Connector for Kafka — download from Maven

Keboola

Available in Partner Connect

Keboola: No requirements

Snowflake: No requirements

Knoema

Available in Partner Connect

Knoema: No requirements

Snowflake: No requirements

Matillion ETL

Available in Partner Connect

Matillion Data Loader: No requirements

Snowflake: No requirements

Matillion ETL

Available in Partner Connect

Matillion ETL: No requirements

Snowflake: No requirements

Nexla

Nexla: No requirements

Snowflake: No requirements (ODBC, JDBC, and API options)

Pentaho

Pentaho Data Integration (PDI):

  • Pentaho 8.3 (or higher): Snowflake plugin — download from the Pentaho Customer Portal (requires login)

  • Pentaho 8.2 (or lower): No Pentaho requirements, but some Snowflake requirements

Snowflake:

Qlik

Available in Partner Connect

Qlik Replicate: No requirements

Snowflake: ODBC Driver — download from the ODBC Download page

Rivery

Available in Partner Connect

Rivery: No requirements

Snowflake: No requirements

SAP Data Services

SAP Data Services: 4.2 SP12 (or higher)

Snowflake: ODBC Driver — download from the ODBC Download page

Segment

Segment: No requirements

Snowflake: No requirements

Skyvia

Skyvia: No requirements

Snowflake: No requirements

Solace

Solace: No requirements

Snowflake: No requirements

SnapLogic

Available in Partner Connect

Snaplogic: 4.7.0 (or higher) with Snowflake Snap Pack

Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository

Snowplow

Snowplow: Snowflake Loader — download from GitHub

Snowflake: No requirements

Stitch

Available in Partner Connect

Stitch: No requirements

Snowflake: No requirements

StreamSets

Available in Partner Connect

StreamSets: No requirements

Snowflake: No requirements

Striim

Available in Partner Connect

Striim: No requirements

Snowflake: No requirements

Supermetrics

Supermetrics: No requirements

Snowflake: No requirements

Tableau Prep

Tableau: Prep 2018.3 (or higher)

Snowflake: ODBC Driver — download from the ODBC Download page

Talend

Available in Partner Connect

Talend:

  • Talend 6.4 (or higher): No requirements

  • Talend 6.3 (or lower): Snowflake component required — contact Talend for details

Snowflake: No requirements

TIBCO Spotfire

TIBCO ActiveMatrix BusinessWorks:

  • 6.x (or higher)

  • Plug-in for Snowflake 6.x (or higher)

Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository

TMMData

TMMData: No requirements

Snowflake: No requirements

Trifacta

Trifacta: No requirements

Snowflake: No requirements

Wherescape

Wherescape: No requirements

Snowflake: No requirements

Workato

Workato: No requirements

Snowflake: No requirements