What is the equivalent of 'yearweek' function in BigQuery standard SQL?
For the result as a string, use '%Y%W' with "format". For example:
select format_date('%Y%W', current_date)
Standard SQL:
select
concat(EXTRACT(ISOYEAR FROM current_date), EXTRACT(ISOWEEK FROM current_date))