Snippets Collections
with account_session_ste as (
FROM `table`
where exists(select 1 from unnest(hits) h 
            where regexp_contains(, r''))
and _table_suffix = FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 4 DAY))
-- group by 1,2)
fullVisitorId AS user_id, as hostname, as pagePath,
hits.hitNumber as hit_number 
-- *
from account_session_ste, unnest(hits) as hits

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension