SELECT * FROM `fieldfocus-13ecd.analytics_186322386.events_*`,
UNNEST(user_properties) user_properties
WHERE user_properties.value.string_value = "Syngenta"
-- AND _TABLE_SUFFIX = '20191022'
AND _TABLE_SUFFIX = FORMAT_DATE("%Y%m%d", DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY))