# \#pivot

**URL:** https://discourse.getdbt.com/tag/pivot/12.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [Auto pivot JSON string using schema.yml in BigQuery](https://discourse.getdbt.com/t/auto-pivot-json-string-using-schema-yml-in-bigquery/1592)

<div class="topic-metadata">

**Author:** [@meurant.naude](https://discourse.getdbt.com/u/meurant.naude)\
**Replies:** 0\
**Last updated:** [September 8, 2020, 9:12pm UTC](https://discourse.getdbt.com/t/auto-pivot-json-string-using-schema-yml-in-bigquery/1592 "2020-09-08T21:12:17Z")

</div>

Let me start by giving you some background and apologies if the background is longer than the solution. Background The scenario: We work with BigQuery Working with events data split into two data sources due to the con…