Home > Workload Solutions > Data Analytics > White Papers > Dell Data Lakehouse build Resilient Data Pipelines > DDAE ETL/ELT capabilities
With its enhanced fault-tolerant execution capabilities, DDAE powered by Starburst Trino has reached a level of maturity suitable for handling production-level, business-critical data pipelines, data transformations, and write operations. This is made possible through the unique feature of query federation.
DDAE MERGE statement enables efficient loading of data into target tables, facilitating streamlined data management processes. Leveraging this feature, dbt-trino extends support for incremental models and snapshot functionalities, enabling users to efficiently manage data updates and changes over time.
It is worth noting that while the MERGE statement brings valuable functionality to DDAE, its usage is limited to a select number of connectors, including Hive, Iceberg, Delta Lake, and others. However, as DDAE’s Trino continues to evolve, we can expect broader support for this feature across additional connectors in the future.
Note: ETL/ELT stand for Extract, Transfer and Load