This message was deleted.

By design, Airbyte first loads data into the destination as raw JSON, then (optionally) runs a normalization/typing step to turn that JSON into columnar tables. [[Full refresh sync](https://airbyte.com/tutorials/full-data-synchronization#step-1)] If you see only a JSON column in BigQuery, it usually means: 1. You’re looking at the raw table (often with

_airbyte_raw_

naming or in the

airbyte_internal

schema for Destinations V2), which intentionally stores each record as a JSON blob to preserve the original data. [[Full refresh sync](https://airbyte.com/tutorials/full-data-synchronization#step-1); [Destinations V2](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2)] 2. Typing/normalization hasn’t been applied or you’re not looking at the final table. With Destinations V2, Airbyte creates typed, columnar “final” tables from those raw JSON blobs; raw JSON is just the first stage. [[Destinations V2](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2)] So the behavior you see (JSON in BigQuery) is expected for the raw data. To get columnar tables, make sure your connection is using a Destinations V2–compatible BigQuery destination and then query the final (non‑`_airbyte_raw_`) tables instead of the raw ones. [[Destinations V2](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2)]