Move past the blank slate with curated templates
BigQuery Studio notebooks bring the power of Colab Enterprise directly into the BigQuery UI, providing a smooth transition between SQL-based data prep, Spark-powered processing, and Python-based analysis. The notebook gallery supports this unified experience with templates tailored to different skill sets and objectives.
-
For SQL developers: Many users are comfortable with SQL but want to explore the expanded capabilities of a notebook environment. Templates in the gallery demonstrate how to use SQL cells to load data and then use visualization cells for no-code charts, making it easier to share insights without writing extensive Python.
-
For data scientists: Python and Spark users can find ready-to-use workflows for data cleaning, transformation, and advanced ML development using BigQuery DataFrames and Spark libraries. These templates follow best practices, so that your code stays efficient and takes full advantage of BigQuery’s distributed engine.
Choose the right template for your project
The gallery is organized to help you find the right starting point for your specific goals, from data analysis and visualization to building advanced data science workflows.
If you’re starting your journey with BigQuery Studio notebooks, the gallery offers several introductory templates:
For seasoned notebook users, you can leverage specialized templates to handle complex analytical workflows:
