At the moment our dashboard is directly backed by BigQuery. However, BigQuery has a limit on the number of "interactive" queries set to 100 by default, and increasing it involves negotiating with Google staff, which likely means it won't go much further. This means we can't really offer this dashboard to the general public, as the required queries will quickly exceed the limit.
Find a way to provide interactive access to our dashboard somehow, so it can handle many more users.
Perhaps add another database, like PostgreSQL, serving as a storage for X months of latest data and use that instead for dashboard.
spbnick
commented
4 years ago
At the moment our dashboard is directly backed by BigQuery. However, BigQuery has a limit on the number of "interactive" queries set to 100 by default, and increasing it involves negotiating with Google staff, which likely means it won't go much further. This means we can't really offer this dashboard to the general public, as the required queries will quickly exceed the limit.
Find a way to provide interactive access to our dashboard somehow, so it can handle many more users.
Perhaps add another database, like PostgreSQL, serving as a storage for X months of latest data and use that instead for dashboard.