Feature: Export the report in a sonarqube specifc form.

[RalfKow]

General situation

I work with dbt and python. I use sonar qube to check my python code but I cant check the created sql with dbt. Is there an option to genereate a report according to the sonar qube required standards? https://docs.sonarsource.com/sonarqube/9.9/analyzing-source-code/importing-external-issues/generic-issue-import-format/

[sweco]

Hey @RalfKow, we were thinking about generating a coverage report in some more standard formats, e.g. Cobertura (#39) or even Sonarqube, but we haven't found time for this so far.

However, I believe you'd be interested in generating issues and not coverage reports, right? Do I imagine it correctly that you'd like to have columns with no documentation marked in the SQL file where the model is described? Or did you mean something else by this?

[RalfKow]

Hey @sweco, thanks for your reply. In my perspective these are two indipendent things. In general I would love to have similar tools like I have in python in on sql/dbt. Let's take python as an example.
In python I basically have several precommit hooks to guarantee a high quality of code. These are:

• isort
• black
• pythondoc
• coverage execute
• coverage create report
• ...

For sql files I basically have

• dbt-compile to check the compilation

• sqlfluff lint to ensure that the sql is written according to the rules

• dbt-test to execute my tests

• ?? to generate a report.

In the end I would like to join the coverage report of python and sql to calculate the coverage of the whole project.

[sweco]

I see, so you'd like to be able to generate a coverage report in a different format (Sonarqube), right? If that's the case, it might indeed make sense to do. 😊

However, we won't have time to do so in the near future but we're open to contribution. It might be sufficient to add a method that would export the data in the particular format, similarly to to_markdown_table.

dbt-coverage/dbt_coverage/__init__.py

Line 353 in 5926212

def to_markdown_table(self):