As we all know Google is continuously improving and expanding the Google Cloud Platform and BigQuery has truly benefited from this. Taking a simple scalable data warehouse into what is now a comprehensive and dynamic system. As you may guess, I’m a massive fan of BigQuery.

BigQuery offers a huge amount of functionality including DDL and DML, however, sometimes, there simply isn’t the function to help you complete what you are doing. Often in the past, I would end up accessing BigQuery via Python or SAS and applying the missing function.

However User Defined Functions cover some of the current…

It’s always a challenge making BigQuery DataWarehouses more efficient. So today I want to share with you the joys of DDL and how you can reduce the time it takes to produce tables from your queries. In the past 6 months BigQuery’s DDL and DML functionality has exploded with plenty of new features and massive time savers, which mean less time spent trying to keep your BigQuery warehouse tidy.

So firstly- what even is DDL and why would you even use it?

DDL stands for Data Definition Language and is primarily used to create and modify tables. …

Lace Chantelle Rogers

Lead data specialist, and programming obsessive. Specialising in data team development. Love statistical languages and focusing on the GCP platform on apps.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store