SQL

The two steps in Dataform execution: Javascript, then SQL statements

Understanding SQLX and Javascript in Dataform

When you think of “programming languages for data,” Javascript probably doesn’t even make the list. Yet, if you’re using Dataform, it’s almost impossible to avoid. As you’ll learn in this article, Dataform is Javascript all the way down. Even SQLX files that you write are pretty much just Javascript files under the covers. So shed …

Understanding SQLX and Javascript in Dataform Read More »

Google Search Console to BigQuery: The Complete Guide to GSC Bulk Export

You may have heard the hype about integrating Google Search Console and Google BigQuery using the new Bulk Export feature. If you’re like me, you recognize the power of analyzing SEO data with SQL or the BI tool of your choice (you’ve probably heard of Looker and Looker Studio.) Or you might be thinking to …

Google Search Console to BigQuery: The Complete Guide to GSC Bulk Export Read More »