Hello Everyone :wave:, Thanks to the Airbyte's te...
# announcements
y
Hello Everyone šŸ‘‹, Thanks to the Airbyte's team for their product. I'm currently building an ELT pipeline from scratch to have a unified Postgres datawarehouse. For me, even if Airbyte is young, it seems to be the good candidate to avoid proprietary cloud softwares (Stitch, Firvetran, ...) without complex setup/maintenance (Meltano, Singer, ...). My targetted BI stack will be Airbyte, DBT, Postgres and Metabase. So I can't wait to use DBT in Airbyte. šŸ˜‰
airbyte rocket 1
šŸ‘‹ 2
šŸ‘Œ 3
k
Are you using DBT and metabase together?
y
No, I'm not. • Airbytes loads raw data from sources into my DB • DBT transforms these raw data to business-oriented data in the same DB. • Metabase reads these business-oriented to create charts.
šŸ™Œ 1
āœ… 1
Am I clear ?
šŸ™Œ 1
b
@Kishore Sahoo I was wondering what you meant by using them together. Are you referring to this https://github.com/gouline/dbt-metabase or is there some other integration you were referring to?
šŸ‘€ 1
y
@Bryan Wise Thanks for sharing. It looks very interesting.
k
My use case is like yours. I want to use DBT on the destination DB then Metabase for Analytics
@Yoann Gotthilf so DBT changes the raw data to business-oriented data in the same DB. So it alters your destination DB on the fly?
I am new to DBT & exploring it.
y
@Kishore Sahoo I'm also exploring DBT. But yes, DBT directly performs the different transformation stages on the DB (DBT sql files are "compiled" to sql queries). You can choose the schema destination.
šŸ‘ 1
Very powerful and easy in my opinion.
k
I am making an analytics application for e-commerce. So planning to Airbyte + DBT + Metabase
šŸ‘ 1