> Markdown version of https://www.artie.com/blogs/why-elts-are-here-to-stay. Site index for AI agents: https://www.artie.com/llms.txt

[Back to blog](https://www.artie.com/blogs)

Data know-how February 27, 2023

# Why ELTs Are Here to Stay

[Robin Tang Co-founder & CTO](https://www.artie.com/authors/robin-tang)

[Share on LinkedIn (opens in a new tab)](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fwww.artie.com%2Fblogs%2Fwhy-elts-are-here-to-stay) [Share on X (opens in a new tab)](https://x.com/intent/post?text=Why%20ELTs%20Are%20Here%20to%20Stay\&url=https%3A%2F%2Fwww.artie.com%2Fblogs%2Fwhy-elts-are-here-to-stay)

Every company nowadays requires data to inform their business decisions. In order to have data be readily accessible and stored in one place, companies have to set up various data integration pipelines.

These are the main components within the data integration stack:

* **Data sources**: this could be a service (internal or external), vendor, data management platforms, etc
* **Data pipelines**: to fetch data from various data sources and transfer them to the destination
* **Data warehouse**: to house and conduct queries against the various data sources

The traditional data integration architecture looks like this:

* Data pipelines **extract** data from the various sources
* Data pipelines then **transforms** it into the specified format
* Data pipelines then **loads** the transformed data into a data warehouse

More recently, there has been a shift towards ELTs. With ELTs, the data integration architecture looks something like this:

* (unchanged) Data pipelines **extract** data from the various sources
* Data pipelines **load** the raw dataset into the data warehouse
* **Transformations** are then done within the data warehouse

**ETL**

Data sources → Extract → Transform – in the pipeline → Load → Data warehouse

**ELT**

Data sources → Extract → Load → Data warehouse – transform here

## What are some examples of transformations?

Simplistically, transformations are any type of manipulation on the raw datasets to present a particular finding or view. Here are some examples of typical data transformations:

* Concatenation (such as combining columns and joining strings)
* Upper / lower case values
* Joining data sets
* Numerical operations (multiply, divide, add, subtract, etc.)
* Grouping data (by customer, by month, etc.)
* Deduplicating data
* Data obfuscation (scrubbing PII or credit card data)

There are endless amounts of possible transforms. To get a better understanding of what additional transformations may look like, [check out all the Snowflake functions](https://docs.snowflake.com/en/sql-reference/functions-all.html)!

## So, why are ELTs better?

1. Transformations are maintained by the team that works closer with the actual data
2. ELTs build upon a self-serve data culture and frees up engineering time
3. More ways to analyze the datasets

**Transformations are maintained by the team that works closer with the actual data**

Transforms can be implemented in SQL or with dbt from the data warehouse, as opposed to custom scripts in the data pipeline. This means that business analysis, data scientists, and others will be able to write their own transforms and maintain the definition.

**ELTs build upon a self-serve data culture and frees up engineering time**

With ELTs, the data team can write their own transformations and not have to rely on the engineering team to write custom scripts.

**More ways to analyze the datasets**

With the ETL approach, the process only outputs and uploads the transformed data set and is extremely rigid. As a result of this, it prevents others from performing additional queries and masks the underlying tables that are referenced in the transformation.

Whereas with ELT, the raw data is loaded into the data warehouse and transformations are done within the data warehouse.

Artie Transfer helps companies adopt and supercharge ELT workflows by providing real-time data replication from transactional databases to your data warehouse.

[Contact us](https://www.artie.com/contact) if you're interested in learning more!

## Related articles

* ### [How to choose a data warehouse](https://www.artie.com/blogs/how-to-choose-a-data-warehouse)

  [Madison Schott](https://www.artie.com/authors/madison-schott)

* ### [What Is a Real-Time Data Warehouse? Architecture, Benefits & Use Cases](https://www.artie.com/blogs/what-is-a-real-time-data-warehouse)

  [Jacqueline Cheong Co-founder & CEO](https://www.artie.com/authors/jacqueline-cheong)

* ### [Best 10 Data Replication Tools for 2026](https://www.artie.com/blogs/best-data-replication-tools)

  [Jacqueline Cheong Co-founder & CEO](https://www.artie.com/authors/jacqueline-cheong)

## We’re a data company

## Watch your data replicate live

[Start for free](https://app.artie.com/signup) [Book a demo](https://www.artie.com/contact)