Destination Bigquery: Field _airbyte_emitted_at has changed type from TIMESTAMP to STRING

[marcosmarxm]

Is this your first time deploying Airbyte : Yes
OS Version / Instance : Debian GNU/Linux 10, GCP, n1-standard-2
Memory / Disk : 7.5Gb / 100Gb SSD
Deployment : Docker / GCP
Airbyte Version : 0.29.15-alpha
Source name/version : Postgresql 0.3.11
Destination name/version : Bigquery 0.4.0
Step : Sync
Description :
Seeing this error happening during sync this morning:

Field _airbyte_emitted_at has changed type from TIMESTAMP to STRING

Could be related to Bigquery destination updated to v0.4.0?Causing sync failure and retries (edited)

[marcosmarxm]

If you’re facing this you need to rollback the BigQuery destination version to 0.3.9.
This was a backward compatibility introduced in 🎉 Destination Bigquery: added gcs upload option by etsybaev · Pull Request #5614 · airbytehq/airbyte · GitHub.
There is a Github issue dealing with this problem: Mysterious switch of data type for <_airbyte_emitted_at> field crashes incremental jobs · Issue #5959 · airbytehq/airbyte · GitHub.
After solving this probably you’ll be able to upgrade to 0.4.1.