search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.64k stars 4.02k forks source link

Destination Snowflake: Destination Connector Snowflake Failing when bringing in Salesforce Order Object #28357

Open cbuckle1 opened 1 year ago

cbuckle1 commented 1 year ago

Connector Name

destination-snowflake

Connector Version

1.2.2

What step the error happened?

None

Revelant information

Failure reason: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: syntax error line 1 at position 54 unexpected 'ORDER'. syntax error line 1 at position 53 unexpected '.'.

working on airbyte/destination-snowflake:1.1.0, but with the upgrade to airbyte/destination-snowflake:1.2.2 started erroring

Relevant log output

destination > ERROR i.a.i.b.AirbyteExceptionHandler(uncaughtException):26 Something went wrong in the connector. See the logs for more details. net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
syntax error line 1 at position 54 unexpected 'ORDER'.
syntax error line 1 at position 53 unexpected '.'.
...
Stack Trace: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
syntax error line 1 at position 54 unexpected 'ORDER'.
syntax error line 1 at position 53 unexpected '.'.

Contribute

cbuckle1 commented 1 year ago

Looks like the same issue as: https://github.com/airbytehq/airbyte/issues/28347 but with Salesforce as the source

gordonkjlee commented 10 months ago

This should be resolved now via https://github.com/airbytehq/airbyte/pull/30319 ?