Tree Structure Creation for Hierarchical Data in Google BigQuery

Learn how to create a tree hierarchy in BigQuery for hierarchical data, a structure in which items are linked to each other via parent-child relationships

[casselsdiego]

This is bad, a much cleaner way to do this is by using CTE recursive.