Introducing PopSQL + dbt. The first SQL editor with built-in dbt supportRead more →

BigQuery

Basics

Get Started with BigQuery and PopSQL in 5 Minutes Accessing BigQuery Public Datasets BigQuery Data Types

Database Management

How to Create a Table How to Drop a Table How to Rename a Table How to Duplicate a Table How to Add a Column How to Drop a Column

Dates and Times

Date and Time Data Types How to Query Date and Time How to Group by Time How to Round Timestamps

Analysis

How to Measure Cohort Retention How to Write a Common Table Expression How to Generate Series to Avoid Gaps in Data How to Calculate Percentiles How to Use countif to Have Multiple Counts

Ready for a modern SQL editor?

Get started for free

Cta