Data Integration¶
Commonly referred to as ETL, data integration encompasses the following 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.
More recent usage references the term ELT, emphasizing that the transformation part of the process 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 definition of data integration has expanded to include a wider range of operations, including:
Data preparation.
Data migration/movement and management.
Data warehouse automation.
Snowflake is known to inter-operate with the following data integration tools:
Solution |
Version / Installation Requirements |
||
|---|---|---|---|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
