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: No requirements — contact Ab Initio for more details Snowflake: ODBC Driver — download from the ODBC Download page
		Agile Data Engine: No requirements Snowflake: No requirements
		Azure Data Factory: No requirements Snowflake: No requirements	Additional resources: Copy activity in Azure Data Factory (Azure Data Factory Documentation) Copy data from and to Snowflake by using Azure Data Factory (Azure Data Factory Documentation)
		Boomi: DCP 4.2 (or higher) or Integration July 2020 (or higher) Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program.
		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	Additional resources: Snowflake - Driver Documentation (CData Software Documentation) Snowflake Integration Guides and Tutorials (CData Software Knowledge Base)
		Datameer: v7 Snowflake: No requirements	Additional resources: Connectors for Cloud Storages — Snowflake (Datameer Documentation) Exporting to Snowflake (Datameer Documentation)
		DataVirtuality: No requirements Snowflake: No requirements	Additional resources: Snowflake Data Warehouse Connector (DataVirtuality website)
		dbt: v0.13 (or higher) Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Getting Started > Supported Databases > Snowflake (dbt Documentation) Building Models > Warehouse-Specific Configs > Snowflake (dbt Documentation) How we configure Snowflake (Fishtown Analytics Blog)
		Denodo: Denodo Platform 6.0 (or higher) Snowflake: No requirements	Additional resources: Denodo Platform 8.0 Datasheet (Denodo website) How to connect to Snowflake from Denodo (Denodo Knowledge Base)
		Diyotta: No requirements Snowflake: No requirements	Additional resources: Working with Snowflake Data Object (Diyotta website)
		Etleap: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Etleap Launches Snowflake Integration (Etleap Blog)
		Etlworks: No requirements Snowflake: No requirements	Additional resources: Etlworks and Snowflake (Etlworks website) Working with Snowflake (Etlworks Documentation)
		Fivetran: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Fivetran and Snowflake integration (Fivetran website)
		Google Cloud Data Fusion: Snowflake plugin Snowflake: No requirements	Additional resources: Cloud Data Fusion Plugins (Google Cloud website) Cloud Storage to Snowflake Action (GitHub)
		Google Cloud Dataflow: Apache Beam Snowflake: No requirements	Additional resources: Snowflake I/O (Apache Beam Documentation) Class SnowflakeIO (Apache Beam Javadoc)
		Heap: Connect Snowflake: No requirements	Additional resources: Heap Connect for Snowflake (Heap Documentation)
		Hevo Data: No requirements Snowflake: No requirements	Additional resources: Destinations > Data Warehouses > Snowflake (Hevo Documentation)
		Hightouch: No requirements Snowflake: No requirements	Additional resources: Activate the Data Cloud (Hightouch website) Sources > Snowflake (Hightouch Documentation)
		HVR: No requirements Snowflake: ODBC Driver — download from the ODBC Download page	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Requirements for Snowflake (HVR Documentation) Quick Start for HVR - Snowflake (HVR Documentation)
		DataStage: InfoSphere Information Server 11.7.0 Snowflake: JDBC Driver — download from Maven	Additional resources: Snowflake connector (IBM Knowledge Center)
		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	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: FAQ: Informatica Cloud Connector for Snowflake (Snowflake Community) Snowflake Cloud Data Warehouse Connector Related Queries (Informatica Network)
		Informatica Data Loader: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Additional resources: How to Video - Getting Started with Informatica Data Loader for Snowflake (Informatica Videos)
		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	Validated by the Snowflake Ready Technology Validation Program. Additional resources: Snowflake Cloud Data Warehouse Connector Related Queries (Informatica Network) PowerExchange for Snowflake User Guide (Informatica Documentation) FAQ: What are the steps to replace data warehouse objects with Snowflake objects in PowerCenter mappings and sessions… (Informatica Network)
		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	Additional requirements if using Avro format; for more details, see Snowflake Connector for Kafka.
		Keboola: No requirements Snowflake: No requirements	Additional resources: Storage (Keboola Documentation) Snowflake Transformation (Keboola Documentation)
		Knoema: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect.
		Matillion Data Loader: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: How to Create a Data Pipeline Using Matillion Data Loader (Matillion Blog)
		Matillion ETL: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Snowflake: How to Get Started (Matillion website) Snowflake articles with videos (Matillion Community)
		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: Pentaho 8.3 (or higher): No requirements Pentaho 8.2 (or lower): . JDBC Driver — download from Maven . or . 3rd-party connector (PentahoSnowflakePlugin) — download from GitHub	Additional resources: PDI and Snowflake (Pentaho Documentation) Bulk load into Snowflake (Pentaho Documentation) PentahoSnowflakePlugin Readme (GitHub) Configuring a JDBC connection to Snowflake Using Pentaho (Snowflake Community)
		Qlik Replicate: No requirements Snowflake: ODBC Driver — download from the ODBC Download page	Formerly Attunity Replicate Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Technology Partners > Snowflake (Qlik website)
		Rivery: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Now Compatible with Snowflake (Rivery website) Integrations: Snowflake (Rivery website) Customer Spotlight: Roomjoom (Rivery website)
		SAP Data Services: 4.2 SP12 (or higher) Snowflake: ODBC Driver — download from the ODBC Download page	Additional resources: Data Services — What’s New (SAP Help Portal) Data Services Supplement for Big Data (SAP Help Portal)
		Segment: No requirements Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program. Additional resources: Snowflake Destination (Segment Documentation)
		Skyvia: No requirements Snowflake: No requirements	Additional resources: Skyvia and Snowflake integration (Skyvia website) Working with Snowflake (Skyvia Documentation)
		Snaplogic: 4.7.0 (or higher) with Snowflake Snap Pack Snowflake: JDBC Driver — download from Maven	Available for trial via Snowflake Partner Connect. Additional resources: Snowflake Snap Pack (SnapLogic Documentation)
		Snowplow: Snowflake Loader — download from GitHub Snowflake: No requirements	Additional resources: Snowflake Loader (Snowplow Documentation)
		Stitch: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Additional resources: Connecting a Snowflake Data Warehouse to Stitch (Stitch Documentation)
		StreamSets: No requirements Snowflake: No requirements	Utilizes Snowpipe for continuous loading. Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Tame Snowflake with StreamSets (StreamSets website)
		Striim: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Striim for Snowflake Data Warehouse (Striim website)
		Supermetrics: No requirements Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program. Additional resources: Snowflake Data Warehouse: Getting started (Supermetrics Documentation)
		Tableau: Prep 2018.3 (or higher) Snowflake: ODBC Driver — download from the ODBC Download page	Additional resources: Snowflake for Tableau Prep (Tableau website)
		Talend: Talend 6.4 (or higher): No requirements Talend 6.3 (or lower): Snowflake component required — contact Talend for details Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Snowflake Components in Talend (Talend Documentation) Centralizing Snowflake Metadata (Talend Documentation)
		TIBCO ActiveMatrix BusinessWorks: 6.x (or higher) Plug-in for Snowflake 6.x (or higher) Snowflake: JDBC Driver — download from Maven	Validated by the Snowflake Ready Technology Validation Program. Additional resources: TIBCO ActiveMatrix BusinessWorks Plug-in for Snowflake User’s Guide (TIBCO Documentation)
		TMMData: No requirements Snowflake: No requirements
		Trifacta: No requirements Snowflake: No requirements	Additional resources: Trifacta for Snowflake (Trifacta website) Trifacta for Snowflake: Data Prep for Your Cloud Data Warehouse or Data Lake — Part 1 (Trifacta blog)
		Wherescape: No requirements Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program. Additional resources: Wherescape Automation for Snowflake (Wherescape website)
		Workato: No requirements Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program. Additional resources: Workato is Snowflake Ready… (Workato Blog) Connectors > Snowflake (Workato Documentation)