Failed To Parse Input String

[anonymous]

@thisisresaa

This is where your error lies

PARSE_DATE**(“%y%m%d”, _TABLE_SUFFIX) >= “2022-11-14”**
AND _TABLE_SUFFIX != “datamart”

Use

PARSE_DATE('%Y%m%d', col_name)

Ref : https://stackoverflow.com/questions/42035651/resolving-failed-to-parse-input-string-error-in-bigquery