BigQuery Table Date Range
See the code
A best practice for time series data in BigQuery is to partition it by dates and store the partitions in individual files or tables. This makes it easy to add, remove and maintain datasets. The partitioned tables can be unioned together and effectively appear as a single table using the table wildcard functions TABLE_DATE_RANGE in Looker. Any user viewing the resulting table can change the date filter, and the query will be rewritten to query the appropriate tables automatically. This Block greatly increases query performance, enabling users to perform crucial time-related analysis.
-
Use-Cases
Sales Product Marketing Customer Success Customer Support Finance
-
Industry
Related Blocks
BigQuery Top “N” Aggregate
Top “N” allows users to isolate the top or bottom data points, based on a selected criteria, in a given data set.
Affinity Analysis
The Looker Block for Affinity Analysis helps users understand how items or events relate to each other.
Sequencing Transactions
The Looker Block for Sequencing Transactions makes it easy to identify trends among returning customers.