What OLAP features are in BigQuery?
Solution 1:
BigQuery is not a traditional OLAP system. The similarity to OLAP is in its ability to rapidly answer multi-dimensional queries. There are no cubes or star/snowflake schema that one might find in a traditional OLAP system. Instead BigQuery excels at ad hoc queries, usually over a large flattened table. If you can share your use case, others on this forum may be able to suggest some best practices to accomplish your goal using BigQuery.