Recursive CTEs in BigQuery
In this practical BigQuery exercise, we’re going to look at what are recursive CTEs and how can they be useful in our tool set.
What is a CTE?
First of all, what is a CTE? Well, it stands for Common Table Expression and is essentially a named query t...
datawise.dev3 min read
Constantin Lungu
Data Engineer
Thanks 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.