Skip to content

Instantly share code, notes, and snippets.

@miketaylr
Created January 20, 2021 17:12
Show Gist options
  • Save miketaylr/4b07867c9ab563b4aa380d1627ae5d23 to your computer and use it in GitHub Desktop.
Save miketaylr/4b07867c9ab563b4aa380d1627ae5d23 to your computer and use it in GitHub Desktop.
accept-ch values in http archive latest (desktop)
select url, accept_ch_value
from (
select distinct NET.REG_DOMAIN(url) as url,
# {"name":"Accept-CH","value":"
REGEXP_EXTRACT(payload, r'(?i)Accept\-CH","value":"(.+?)"') as accept_ch_value
from
`httparchive.latest.requests_desktop`
where
JSON_EXTRACT(payload, '$._headers.response') LIKE '%CH-%'
)
where accept_ch_value is not null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment