Simple query that demonstrates the issue,
Select DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY)
Step Logic Step 14 failed: Encountered " <ID> "DAY "" at line 1, column 45. Was expecting: ")" ... [Try using standard SQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql)]
I can confirm the query works with Standard SQL on BigQuery.
Wondering if anyone has any ideas.