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