in case interested there is a dbt-exasol adapter that I developed with my colleagues. It currently works, but needs a little patch for dbt because of keyword usage. I am currently trying to get the patch into the dbt main release.
In case of any questions or other bugs/problems please feel free to contact me.
One of my colleages tipped me off about dbt, it seems like a great tool and I look forward to playing around with it!
Torsten, what has your experience been so far? Any particular things to keep in mind for Exasol specifically?
Well, experience has been good - great in fact. Since it is all about the SQL being prepared and sent directly to Exasol there is really not much that could be wrong in regards to DBT and Exasol - because the added layer by DBT is very lightweight and flexible. You decide on your own and depending on the project how much DBT/Macro/Jinja additions are to be introduced in your project or as needed.
Most important is do some quick tests in the beginning with your sample data and tooling - then take a step back and have some team meeting to agree on project standards regarding SQL-standards, project layout and data architecture. But the DBT defaults from their website are quite descend already - not much difference there between Exasol and the other DWH / Analytics databases (except Exasol is the easiest and fastest, of course :-))
Thanks Torsten for sharing this, lets have a quick call and discuss how we can further promote and feature this in the community. Please DM me in the Community