BigQuery is one of the most well-known data warehouses and it’s great at handling large datasets. However, due to its distributed architecture, it will never give you a sub-second response, on any dataset.

For application developers, building an app directly on top of BigQuery means having substantial wait time on dashboards and charts, especially if they’re dynamic (where users can select different date ranges or change filters). Most certainly, we can tolerate that for internal apps, but not for the public-facing apps that we ship to customers.

Source: DZone