Using the BigQuery
STRUCT data type allows for better performance and validation on JSON data. Does Fivetran support the
STRUCT data type?
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.