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