BigQuery with Cube JS best practices

Hi,

I just read Cube.js API with BigQuery | Real Time Dashboard Guide that gives a glance in a possible setup of Cube JS with BigQuery. But as suggested in the article, BigQuery isn’t designed for subsecond responses but more for handling complex analytical queries.

When using BI Engine, you can still get away with subsecond query results.

But what is the best practice if you want to build a scalable API service that gives the desired performance and can handle the reporting and analytics queries that come in through Cube JS to serve end user facing apps?

@Abdel The key point here is a reasonable usage of cache and pre-aggregations. This is one of the main Cube features that allow you to set up these things and control them without the need of reinventing something on your own.