What OLAP features are in BigQuery?
google-bigquery, olap
Solution
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.
Problem
In the BigQuery documentation it is mentioned that it uses OLAP functions. But the developer documentation does not mention MDX query language, dimension or fact tables. What OLAP features, if any, are in BQ and how are they