@kapa.ai Is there a way to get the JSON columns as nested columns in Destination - Bigquery

Based on the provided knowledge sources, I can answer your question about getting JSON columns as nested columns in BigQuery when using Airbyte. With Airbyte's Destinations V2, JSON columns are not automatically expanded into nested columns in BigQuery. Instead, they are stored as JSON columns. This is a change from the previous behavior where Airbyte would "unnest" objects into separate tables. According to the [Destinations V2 Implementation Differences](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2#destinations-v2-implementation-differences) documentation: > Object and array properties are properly stored as JSON columns This means that nested objects and arrays in your source data will be kept as JSON in BigQuery, rather than being expanded into separate columns or tables. If you need to work with the nested data, you have a few options: 1. Use BigQuery's JSON querying capabilities to access the nested data directly. 2. Create views in BigQuery to flatten the JSON data. 3. Use a tool like dbt to transform the JSON data into the desired structure after it has been loaded into BigQuery. An Airbyte contributor mentioned in a [GitHub comment](https://github.com/airbytehq/airbyte/issues/25194): > Tools like dbt are great at this, and the JSON-querying abilities of most data warehouses these days is pretty good, so you can make a view as well. It's worth noting that this change was made to simplify the data loading process and provide more flexibility for users to handle complex data structures according to their specific needs. If you absolutely need the nested structure in BigQuery and can't use the above methods, you might need to consider alternative approaches or tools outside of Airbyte's standard functionality.