Source Zendesk Support: Negative IDs / integers for Zendesk Support connection

Connector Questions & Issues
,
1
  • Is this your first time deploying Airbyte? No
  • OS Version / Instance: Ubuntu / AWS EC2
  • Memory / Disk: m5.2xlarge - 8 CPU, 32 GB Memory
  • Deployment: Docker
  • Airbyte Version: 0.39.14-alpha
  • Source name/version: airbyte/source-zendesk-support:0.2.15
  • Destination name/version: airbyte/destination-s3:0.3.14
  • Step:
  1. Create a connection between Zendesk Support and S3, in a parquet format.
  2. Query the data (in that case, using Athena). It will be possible to see IDs as negative floats when it should be integers. Also, the numbers don’t match the original ID on Zendesk. Example with Zendesk Ticket Comments table:
    image
    image1099Ă—478 57.7 KB
  • Description: Some additional comments;
    • This doesn’t happen to other sources, apparently only with Zendesk.
    • My assumption is that Zendesk provides some big integers for some columns. When the code converts data to a parquet, it “changes” the values.
2

Hi @israel.mendes, I think your assumption is correct and if that’s the case, we can most likely have a community contribution to fix the error.

I escalated the issue to github here: https://github.com/airbytehq/airbyte/issues/16367. Please follow there for updates.

1 Like
3

I will follow up on Github then, thanks @sajarin!

4

Hi @sajarin , I am facing exact same issue with MySQL Source. The destination is same as @israel.mendes 's which is S3 in parquet format.
Can you help me here or guide to any thread?