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 Snowflake Client Repository
		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.
		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: Integrate Your Data into Snowflake (DataVirtuality website)
		dbt: v0.13 (or higher) Snowflake: No requirements	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 6.0 (Denodo data sheet)
		Diyotta: No requirements Snowflake: No requirements	Additional resources: Diyotta and Snowflake (Diyotta website) Replatforming: Netezza to Snowflake (Diyotta Datasheet — requires registration)
		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)
		HVR: No requirements Snowflake: ODBC Driver — download from the Snowflake Client Repository	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 Snowflake Client Repository 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 PowerCenter: PowerCenter 10.2 (or higher) PowerExchange for Snowflake Snowflake: For push-down optimization: ODBC Driver — download from the Snowflake Client Repository 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)
		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 Snowflake Client Repository	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 Snowflake Client Repository	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)
		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: Snowplow Snowflake DB Loader released (Snowplow Blog)
		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	Validated by the Snowflake Ready Technology Validation Program. Utilizes Snowpipe for continuous loading. 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)
		Tableau: Prep 2018.3 (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository	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)
		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)