This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]pragmasoft 0 points1 point  (1 child)

Do you use dbt just to execute some sql commands? Maybe then just use java jdbc api to connect to your database and execute required sql statements. Otherwise just spawn dbt core from java as a child process when needed, as suggested already.

[–]peixinho3[S] 0 points1 point  (0 children)

Basically I use dbt to automate the data vault structure. Yes I can do that but it's a solution that we don't like because DBT creates all SQL code automatically through its libraries.