[Analytics Engineering] Flattening JSON with a recursive query in BigQuery
Ali, Saqib docbook.xml at gmail.com
Wed Mar 13 16:52:11 UTC 2024
An interesting post by Ross Lovelace on how to flatten a nested JSON using a SQL Recursive CTE:
https://medium.com/@rossalovelace/flattening-json-with-a-recursive-query-in-bigquery-a8cf76eedca8
- Previous message (by thread): [Wranglers] Webinar: Build for scale, agility, and reliability with dbt Cloud, AutomateDV, and Data Vault
- Next message (by thread): [Wranglers] Syntactic Sugar: Snowflake Now Supports Trailing Comma for the SELECT Clause