Search code examples
pythonjsonreportingdbt

Can the results of dbt test be converted to report

I am using DBT (data build tool) as an ETL tool for data analytics . The command dbt test Resuts in the test cases being pass/fail on the output terminal but need to export this result into JSON/HTML/XML format for reporting.

Any help in this regard ?

Solution

  • If you are executing this on an UNIX shell like Mac or Linux, you can try with tee like this.

    dbt run | tee -a your_log_file.txt

    This will create and append there on the a log file of your choosing for whatever results of the dbt run command.