- Explore
- Collaborate
- Visualize
- Connect
Pricing

Sign In Get Started

PopSQL

Explore

SQL Editor Data catalog Query variables

Collaborate

Shared queries Search Version history

Visualize

Dashboards Charts Notebooks

Connect

Connections Scheduled queries dbt

Changelog Blog Docs Customers Tutorials Templates Buyers' guide

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