z3z1ma / dbt-osmosis

Provides automated YAML management, a dbt server, streamlit workbench, and git-integrated dbt model output diff tools
https://z3z1ma.github.io/dbt-osmosis/
Apache License 2.0
422 stars 45 forks source link

Feature request: `dbt-osmosis yaml audit` #28

Closed ireyna-modo closed 10 months ago

ireyna-modo commented 1 year ago

I think it would be pretty useful to have a command to execute the audit standalone. For example this line dbt-osmosis yaml audit -f development.test would have the following output:

             ✅ Audit Report                                                                                                                                                                                                               
             -------------------------------                                                                                                                                                                                               

             Database: awsdatacatalog                                                                                                                                                                                                      
             Schema: development                                                                                                                                                                                                 
             Table: test                                                                                                                                                                                                          

             Total Columns in Database: 3.0
             Total Documentation Coverage: 100.0%        

             Action Log:                                                                                                                                                                                                                   
             Columns Added to dbt: 2                                                                                                                                                                                                     
             Column Knowledge Inherited: 1                                                                                                                                                                                                 
             Extra Columns Removed: 0   

Then, one would be able to do whatever they want with it: post it as a comment in a PR or send it as a Slack message, etc

z3z1ma commented 10 months ago

We have moved away from the standalone audits for now, the focus is narrow on purely automating most of the work. We may revisit at another point if someone takes another stab at the feature or dbt core implements it themselves