CLThanks Shreyan Das! Most of the time, this usecase is only a small part of the bigger data pipeline (say you'd need to work out the company hierarchy and who reports to whom). Otherwise if your entire application is centered on graph semantics, yes probably need to look at a specialized solution.Comment·Article·Jun 21, 2024·Recursive CTEs in BigQuery
CLThanks for reading Thomas Sambruni! INFORMATION_SCHEMA is indeed very useful, albeit sometimes overwhelming to use.Reply·Article·Oct 13, 2023·The power of BigQuery INFORMATION_SCHEMA views