Build a Data Lakehouse Reporting Structure with dbt and Starburst Galaxy

Monica Miller details her journey from skepticism to advocacy in integrating dbt with Starburst Galaxy to create a federated data lakehouse reporting structure. Initially hesitant about dbt due to the complexities of centralizing data from multiple locations, Miller eventually embraced its transformative power when combined with Trino, allowing her to federate data from various sources like S3, Snowflake, and the TPC-H dataset into one cohesive system. This integration not only addresses the challenges of accessing disparate data sources but also facilitates communication between different data platforms, enhancing data analysis and insights. Through a tutorial, Miller demonstrates how to build a data lakehouse architecture using Iceberg table formats on S3, highlighting the practicality and efficiency of using dbt and Starburst Galaxy together. By offering pre-built models and detailed instructions, the tutorial aims to help users quickly understand and implement this innovative solution in their own environments.