Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Filtering events in bigquery using partitions
SELECT
count(*) as events
FROM `<project-name>.analytics_<id>.events_*`
WHERE _TABLE_SUFFIX >= FORMAT_DATE('%Y%m%d', CURRENT_DATE() - 7)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment