MySQL to BigQuery Sync Issue with Unsigned Bigint

Summary

The user reports an issue where an ‘unsigned bigint’ column in MySQL is being converted to an integer type in BigQuery instead of the expected numeric type during synchronization, impacting multiple services reliant on the correct datatype.


Question

Hello, I am facing strange behavior when syncing MySQL to GCP BigQuery, our table has an “unsigned bigint” column which is getting converted into integer when reaching BQ. The correct translation would be numeric so im not sure why is it casting it into integer. We are trying to migrate into Airbyte and this is kinda of holding us back since we have multiple services that connect to BQ and expect the numeric datatype.



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['mysql', 'bigquery', 'unsigned-bignit', 'data-type-conversion', 'airbyte']