> Our current platform connects directly to SQL databases and warehouses. We don't copy, cache, or manage any data.
Well that may be convenient for you but since these dashboards are external, does scalability become the responsibility of your customers? I can’t imagine thousands of users all hammering expensive analytical queries on a single unoptimized replica will scale very well.
Scalability is definitely something we're thinking about. Agreed that a single replica DB probably won't work well after a certain extent. Currently we do help customers to set up a data warehouse and optimized data model in Snowflake or other sources if needed.
We also refer customers to services or contractors who help them set up a their data infra to fit their needs as it's not the core focus of our product.
We have also thought about implementing a caching layer to improve performance, although that adds a few hurdles regarding data privacy and pulling live data.
Well that may be convenient for you but since these dashboards are external, does scalability become the responsibility of your customers? I can’t imagine thousands of users all hammering expensive analytical queries on a single unoptimized replica will scale very well.