Does anyone have Onfleet as a source, using Onfleet (v1.0.0)? In attempting to sync to Snowflake, using Snowflake (v3.2.3), I receive an error, but a sync to SQLite, using SQLite (v2.4.9) is successful.
The Snowflake sync error in the log is:
ERR failed to write batch error="failed to put file into stage with last resource put file://C:\\Users\\ED29FE~1.WIN\\AppData\\Local\\Temp\\onfleet_admins.json.1159616259 @cq_plugin_stage auto_compress=true: 001003 (42000): SQL compilation error:
syntax error line 1 at position 26 unexpected '~'.
parse error line 1 at position 33 near '65'.
parse error line 1 at position 41 near '76'.
parse error line 1 at position 47 near '84'.
parse error line 1 at position 52 near '111'.
syntax error line 1 at position 66 unexpected '.'.
syntax error line 1 at position 71 unexpected '.1159616259'.
syntax error line 1 at position 83 unexpected '@cq_plugin_stage'." duration=68.2582 len=2 module=snowflake-src table=onfleet_admins
Is there a more recent Onfleet source plugin that may have addressed syncing to Snowflake, or is there something I need to add to my YAML files?
Would you mind sharing your CQ configuration with any sensitive information redacted?
I am encountering an OnFleet → Snowflake sync error. One potential problem is that the source and destination have incompatible plugin-sdk versions. Since OnFleet is a partner plugin, they may not be using the latest plugin SDK version.
To test this, we can try using older versions of the destination plugin. Could you try: