Great article! This is exactly the use case we created dbt Charts for. If you're thinking of making a system like this, do consider us for your Chartifact format. You can host it locally, in streamlit, or with our provided hosting that adds some nice UI, agents, permissions, Claude connectors, etc. We've also got some Looker and other tool migrators :).
https://dbtcharts.com