Source Freshdesk: Normalization failure Numeric value is not recognized

Connector Questions & Issues
1
  • Source name/version: freshdesk:0.2.5
  • Destination name/version: snowflake:0.3.12
  • Step: Sync
  • Description: I’m trying to sync data from Freshdesk and normalization is failing.
2021-08-31 19:10:48 INFO () LineGobbler(voidCall):85 - e[33mDatabase Error in model FRESHDESK_CONTACTS (models/generated/airbyte_tables/FRESHDESK/FRESHDESK_CONTACTS.sql)e[0m
2021-08-31 19:10:48 INFO () LineGobbler(voidCall):85 -   100038 (22018): Numeric value '0fB5KB39f6NUHhkmTorbn7L3BMC2' is not recognized
2021-08-31 19:10:48 INFO () LineGobbler(voidCall):85 -   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/FRESHDESK/FRESHDESK_CONTACTS.sql
2021-08-31 19:10:48 INFO () LineGobbler(voidCall):85 -
2

A Github issue was open to solve the problem: Problem with the schema for the contact stream · Issue #5800 · airbytehq/airbyte · GitHub
A workaround is disable the contact stream.

3

Update your connector to version 0.2.6