Hey yall do any of you output the actual SQL that is being e

Question

Hey yall do any of you output the actual SQL that is being executed by DBT in your dagster logs If so how exactly do I enable that

Adam Bloom · Answer

dbt doesn t log that it writes it out to a file in your dbt profile s `target` directory

Zachary Bluhm · Answer

It does seem that if you pass in the ` d` arg that it will be output in the logs but with a bunch of other stuff that we d rather not output But I m not sure how to pass that arg in to the DBT cli resource

Adam Bloom · Answer

`context resources dbt run debug=True `

Adam Bloom · Answer

You can pass additional keyword arguments I haven t actually tested this but that should add the ` debug` flag to the command used to invoke dbt which is equivalent to ` d`

Zachary Bluhm · Answer

can you set this when creating the resource itself i e when calling `dbt cli resource configured `

Adam Bloom · Answer

no it isn t a supported config option