BigQuery destination field data type

  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Ubuntu
  • Memory / Disk:32GB / 32GB
  • Deployment: Docker
  • Airbyte Version: 0.40.0-alpha
  • Source name/version: MySQL 0.6.9
  • Destination name/version: BigQuery 1.1.16
  • Step: After replication all date columns change to STRING
  • Description: After replication all date columns change to STRING except the Airbyte emitted at column


How can I change the other columns to TIMESTAMP

Hello, thanks for submitting this question!

Here is our documentation on the BigQuery destination connector: https://docs.airbyte.com/integrations/destinations/bigquery#data-type-map

Could you share some more information about the source schema? Which datatypes are changing to STRING?

Also, if you’re able to share some records from the table you are having issues with, that would be very helpful when we try to reproduce the issue.