Google Big Query Doesn't Support JSON, ARRAY or STRUCT types

Google Big Query Doesn't Support JSON, ARRAY or STRUCT types

When working with Array or Struct types in BigQuery you cannot select any columns using these types for mapping.

Having JSON type columns crashes the task creation wizard stopping you form being able to create a mapping.