Edit on GitHub
Error: Syntax Error: Expected “(“ or “,” or Keyword SELECT but Got Keyword WITHlink
Issuelink
A transformation is successful when you run it locally. However, when you run it in Fivetran, the following error appears in the transformation run logs:
Syntax error: Expected "(" or "," or keyword SELECT but got keyword WITH.
Environmentlink
Transformations for dbt Core
Resolutionlink
To resolve this issue, grant ownership permission of the table in the destination to the authenticating user.
Causelink
This issue occurs when the authenticating user does not have ownership permission on the table in the destination.