search

brooklyn-data / dbt_artifacts

A dbt package for modelling dbt metadata. https://brooklyn-data.github.io/dbt_artifacts
Apache License 2.0
333 stars 126 forks source link

[Bug]: ROWS_AFFECTED column in table FCT_DBT__MODEL_EXECUTIONS shows always 1 #407

Open sushildjoshi opened 12 months ago

sushildjoshi commented 12 months ago

I added dbt_artifacts in my project and then run one model.

after this when I query this table for specific model run I can see rows_affected is always showing as 1 and not actual number of rows loaded as part of run.

as part of my run, there are 100 records loaded in my table so I am expecting same 100 value should show in column rows_affected present in table FCT_DBT__MODEL_EXECUTIONS .

please help to fix this as this will be big saver to quickly see how many records got loaded as part my latest model execution.

Thanks a lot in advance for all your help !

jared-rimmer commented 10 months ago

Hi @sushildjoshi are you able to provide any more context on this error: