SQL on logic step fails

Discussions Logic
1

Using BigQuery.
Simple query that demonstrates the issue,

Select DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY)

Error:

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.

2

Hi Ruben!

It seems you just need to change the logic step type to ‘Standard SQL’:

image
image716×447 21.6 KB

3

Hi Taylor,

Thank you!

The error makes it sound like the issue is with the query not being valid. I didn’t even think to look at the options on Rivery.