BigQuery destination field data type

Connector Questions & Issues
,
1
  • 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

Screenshot 2022-09-08 at 15.58.32
Screenshot 2022-09-08 at 15.58.321062×630 122 KB

How can I change the other columns to TIMESTAMP

2

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.

3

yes I think only date columns having this issue.
they automatically change into string