Announcing our $3.4M seed round
from Gradient Ventures, FundersClub, and Y Combinator
🚀
Read more →
Product
Shared queries
Editor
Version history
Data catalog
Query variables
Dashboards
Scheduled queries
Charts
Search
Connections
Pricing
Docs
Learn SQL
Tutorials
Templates
Blog
Contact
Sign In
Get Started
Sign In
PopSQL
Product
Shared queries
Editor
Version history
Data catalog
Query variables
Dashboards
Scheduled queries
Charts
Search
Connections
Pricing
Docs
Learn SQL
Tutorials
Templates
Blog
Get Started
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