Dremio and Apache Iceberg are two powerful tools that can be leveraged to create a powerful data lakehouse solution. In this Youtube video, Dremio Developer Advocate, Alex Merced, demonstrates how to do Data Manipulation Language (DML) on Apache Iceberg tables from Dremio using a MERGE INTO/upsert example.

A data lakehouse is a modern data platform solution that combines the best of both data warehouses and data lakes. Using Apache Iceberg, it is possible to create a unified system that combines the flexibility of a data lake with the performance of a data warehouse. This makes it easier for organizations to access and analyze multiple types of datasets without having to manage multiple platforms.

Apache Iceberg is an open source table format for storing large, slow-moving tabular datasets in distributed storage systems such as Amazon S3 or HDFS. It provides support for snapshot isolation, multi-level ACID transactions and complex queries on petabyte-scale datasets. This makes it easier for organizations to store and query large amounts of data without having to manage multiple systems.

Dremio is an open source Data Lake Engine that makes it easy for organizations to query their Apache Iceberg tables from within their preferred BI or visualization tool. It provides support for powerful SQL queries, as well as advanced analytics such as machine learning and graph analytics.

In this video, Alex Merced demonstrates how to use Dremio’s MERGE INTO command to do DML operations on Apache Iceberg tables from within Dremio. He shows how this can be used to upsert (update or insert) records into an existing table in order to keep the dataset up-to-date with the latest changes. This makes it easier for organizations to keep their datasets up-to-date without having to manually update them each time something changes.

By leveraging the power of both Apache Iceberg and Dremio, organizations can create a powerful data lakehouse solution that allows them to access and analyze multiple types of datasets quickly and easily without having to manage multiple systems. With Dremio’s MERGE INTO command, they can also keep their datasets up-to-date with the latest changes in order to ensure accuracy and consistency across all their systems.

This Youtube video provides an excellent demonstration of how these two tools can be used together in order to create a powerful Data Lakehouse solution that allows organizations to access and analyze massive amounts of data quickly and easily without having to manage multiple platforms or manually update their datasets each time something changes

Connect with us!

Twitter: [ Ссылка ]
LinkedIn: [ Ссылка ]
Facebook: [ Ссылка ]
Community Forum: [ Ссылка ]
Github: [ Ссылка ]
Blog: [ Ссылка ]
Questions?: [ Ссылка ]
Website: [ Ссылка ]

свернуть