# Can we use DBT as a Code Coverage Tool and what kind of Code Coverage Report Formats does DBT generate?

**URL:** <https://discourse.getdbt.com/t/can-we-use-dbt-as-a-code-coverage-tool-and-what-kind-of-code-coverage-report-formats-does-dbt-generate/5796>\
**Category:** In-Depth Discussions\
**Tags:** best-practice, snowflake, dbt-cloud\
**Created:** [December 21, 2022, 11:24am UTC](https://discourse.getdbt.com/t/can-we-use-dbt-as-a-code-coverage-tool-and-what-kind-of-code-coverage-report-formats-does-dbt-generate/5796 "2022-12-21T11:24:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![smk.yadav22](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/smk.yadav22/32/1510_2.png) [@smk.yadav22](https://discourse.getdbt.com/u/smk.yadav22)\
**Post date:** [December 21, 2022, 11:24am UTC](https://discourse.getdbt.com/t/can-we-use-dbt-as-a-code-coverage-tool-and-what-kind-of-code-coverage-report-formats-does-dbt-generate/5796/1 "2022-12-21T11:24:26Z")

</div>

Hi Team,

We are trying to generate Code Coverage for SQL code using DBT tool. We need to understand the set up and configuration for dbt tool. So regarding DBT, I have the below queries.

1. Can we use DBT as a Code Coverage Tool ?

If Yes,  
2. What kind of Code Coverage Report Formats does DBT generates (Ex: HTML, XML or CSV).

1. Is there any sample repository to generate Code Coverage for SQL using DBT tool.

Thanks,  
Murali Sulam

---

<div class="post-metadata">

**Author:** ![smk.yadav22](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/smk.yadav22/32/1510_2.png) [@smk.yadav22](https://discourse.getdbt.com/u/smk.yadav22)\
**Post date:** [December 26, 2022, 1:43pm UTC](https://discourse.getdbt.com/t/can-we-use-dbt-as-a-code-coverage-tool-and-what-kind-of-code-coverage-report-formats-does-dbt-generate/5796/2 "2022-12-26T13:43:53Z")

</div>

Hi Team,

Any update on the above query?

Regards,  
Murali Sulam

---

<div class="post-metadata">

**Author:** ![smk.yadav22](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/smk.yadav22/32/1510_2.png) [@smk.yadav22](https://discourse.getdbt.com/u/smk.yadav22)\
**Post date:** [January 5, 2023, 6:44am UTC](https://discourse.getdbt.com/t/can-we-use-dbt-as-a-code-coverage-tool-and-what-kind-of-code-coverage-report-formats-does-dbt-generate/5796/3 "2023-01-05T06:44:07Z")

</div>

Hi Team,

It’s been almost a month I have raised this query, but still now I didn’t get any Update. Could you please let me know the update on the above mentioned query.

Thanks,  
Murali Sulam

---

<div class="post-metadata">

**Author:** ![wefo](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/wefo/32/1632_2.png) [@wefo](https://discourse.getdbt.com/u/wefo)\
**Post date:** [January 14, 2023, 12:11pm UTC](https://discourse.getdbt.com/t/can-we-use-dbt-as-a-code-coverage-tool-and-what-kind-of-code-coverage-report-formats-does-dbt-generate/5796/4 "2023-01-14T12:11:53Z")

</div>

Hey @smk.yadav22

Have you checked this dbt package [GitHub - slidoapp/dbt-coverage: One-stop-shop for docs and test coverage of dbt projects.](https://github.com/slidoapp/dbt-coverage)?

It reports how well your models are documented and how many models have associated tests.