Our DBT Cloud jobs started failing after Elementary was upgraded from 23.1 to 24.0 with the error.
Database Error
001003 (42000): SQL compilation error:
syntax error line 9 at position 4 unexpected 'order'.
Reverting back to 23.1 resolved the error.
This is DBT Cloud running jobs on Snowflake. ORDER is a reserved keyword so if it's going to be used it need double quotes around it "order".
Our DBT Cloud jobs started failing after Elementary was upgraded from 23.1 to 24.0 with the error.
Database Error
001003 (42000): SQL compilation error:
syntax error line 9 at position 4 unexpected 'order'.
Reverting back to 23.1 resolved the error.
This is DBT Cloud running jobs on Snowflake. ORDER is a reserved keyword so if it's going to be used it need double quotes around it "order".