alt Hacker NewsThat's super interesting!
With Kavla I want to lean into the exploring/debugging phase for analytics. "Embrace the mess", in a way.
My vision is that there will be an "export to dbt" button when you're ready to standardize a dashboard.
What made you pick count? Was spaghetti the major reason you left count, or something else?
The choice to use Count was made before I joined the company; IIRC they migrated to it from Tableau.
We wanted to migrate (to Streamlit, back then) to have the SQL not live locked in a tool, but inside our git repository; to be able to run tests on the logic etc. But the spaghetti mess was felt too, even if it wasn't the main reason to switch.
(But then, 1) some team changes happened that pushed us towards Metabase, and 2) we found that Streamlit managed by Snowflake is quite costly, compute-time wise. (The compute server that starts when you open a Streamlit report, stays live for tens of minutes, which was unexpected to us.)
----
Export to DBT sounds great. Count has "export to SQL" which walks the graph of the cell dependencies and collects them into a CTE. I can imagine there being a way to export into a ZIP of SQL+YML files, with one SQL file per cell.