https://dagster.io/ logo
#integration-dbt
Title
# integration-dbt
c

Chris Dong

11/30/2022, 8:33 PM
Does dagster have native support for dbt tests? For example, would like to • prevent pipeline from running if it fails dbt test DQ check • visually see in the UI if any assets are failing any DQ checks from dbt test
r

rex

11/30/2022, 8:39 PM
I’m assuming that you’re loading your dbt assets from dbt Core. On
load_assets_from_dbt_manifest
and
load_assets_from_dbt_project
, there’s an argument for
use_build_command
. This will run your dbt tests alongside your models - if your models fail the tests, I believe that it will display as failed in the UI. @owen would know best regarding the behavior of this interface
o

owen

11/30/2022, 10:56 PM
hi! the result of each dbt test that's executed when you set
use_build_command=True
will be represented as an AssetObservation, so you'll be able to see if the test is passing or failing on the asset details page for the given asset, but at the moment asset observations do not result in other sorts of visual indicators in the UI.
a

Adam Bloom

12/01/2022, 12:01 AM
@owen might be a separate discussion, but are there plans to add any sort of visual indicator to the UI? I'm currently running tests via a separate op (using dbt build has some side effects that I want to avoid) - I could add the asset observations to that op I suppose? (it's currently triggered via a multi-asset sensor, so the asset list is known)
❤️ 1
o

owen

12/01/2022, 5:22 PM
@Adam Bloom we've done some thinking about a potential "Asset Expectations" feature, which would be a more specialized version of asset observations (which simply record arbitrary metadata) -- so I'd say that it's not on the immediate roadmap but something that we do eventually plan to support
21 Views