Skip to content

Instantly share code, notes, and snippets.

@allyburns

allyburns/ga_code_0002_wildcard_select Secret

Created June 14, 2023 11:09
Show Gist options
  • Save allyburns/11d23def78c9fafddcc236f0a1012d75 to your computer and use it in GitHub Desktop.
Save allyburns/11d23def78c9fafddcc236f0a1012d75 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ga_code_0002_wildcard_select
SELECT DISTINCT (_table_suffix)
FROM `example_project.analytics_348840650.events_intraday_*`
WHERE
_table_suffix
BETWEEN
format_date('%Y%m%d',date_sub(current_date(), interval 7 day))
AND
format_date('%Y%m%d', current_date())
ORDER BY _table_suffix
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment