Snowflake's cache is a cost saver if the dashboard runs the same SQL again and the underlying data has not changed.
GizmoSQL would take the rows from that first query and hold them in DuckDB temporarily. Subsequent questions on the dashboard would save over 50% of the customer's bill.
Blog: https://www.linkedin.com/pulse/how-gizmosql-could-change-uni...
If the customer spends less on their data warehouse bill querying data with the AI Analyst, they have an incentive to spend more money bringing more revenue for the tools.
I built a simulation showing the cost savings driving revenue.