Question
Using the BigQuery STRUCT data type allows for better performance and validation on JSON data. Does Fivetran support the STRUCT data type?
Environment
Destination: BigQuery
Answer
The STRUCT data type is incompatible with automatic schema migration. It is recommended that you use a Transformation to create a new column as STRUCT to optimize your downstream queries.