Unable to Query ORDER Tables in Snowflake

Issue

Querying an ORDER table in Snowflake results in a syntax error.

Environment

Destination: Snowflake

Resolution

To resolve this issue, wrap the table name in double quotes so that Snowflake interprets it as an identifier. For example:

SELECT *
FROM <schema>."ORDER"

Alternatively, rename the table to avoid using a reserved keyword.

Cause

ORDER is a reserved keyword in Snowflake. When you reference a table that shares its name with a reserved keyword without quoting it, Snowflake returns a syntax error. For more information, see Snowflake's Reserved & limited keywords documentation.