Loops in BigQuery

Learn how to use BigQuery scripting to calculate Fibonacci numbers with for loops

Ever wanted to loop around stuff in SQL? Well, you can with scripting. Let’s see how we can calculate Fibonacci numbers in BigQuery with loops.

Do the loop in BigQuery! — Photo by Claire Satera on Unsplash

I previously showed how to do Fibonacci in BigQuery with JavaScript UDFs (user-defined functions) and also talked about arrays in…