Source Hubspot: Engagement stream on Bigquery(denormalized) - field: metadata incompatible type

[wei-kortx]

Connector Name

source-hubspot

Connector Version

1.0.1

What step the error happened?

During the sync

Revelant information

The Hubspot engagement stream is failing on sync when using Bigquery(denormalized-typed-struct) destination due to incompatible data type for certain field.

The stream will sync successfully if the metadata field is disabled.

The same stream did not have any issue using the regular version of Bigquery destination.

Relevant log output

For more details see Big Query Error collection: BigQueryError{reason=invalidQuery, location=query, message=Field metadata.threadId has incompatible types. Configured schema: string; Avro file: record.}:

Contribute

• Yes, I want to contribute