BigQuery How-To Guides

Practical BigQuery answers with statements you can copy and run.

• How to Count Distinct Values in BigQuery
• How to Use Window Functions in BigQuery
• How to Unnest Arrays in BigQuery
• How to Work with Dates in BigQuery
• How to Use DATE_DIFF in BigQuery
• How to Use DATE_TRUNC in BigQuery
• How to Format Dates in BigQuery
• How to Concatenate Strings in BigQuery
• How to Use String Functions in BigQuery
• How to Check if a String Contains a Substring in BigQuery
• How to Use Regex in BigQuery
• How to Use STRING_AGG in BigQuery
• How to Convert an Array to a String in BigQuery
• How to Use Arrays in BigQuery
• How to Handle NULLs in BigQuery
• How to Cast Data Types in BigQuery
• How to Query JSON in BigQuery
• DATE vs DATETIME vs TIMESTAMP in BigQuery
• How to Create a Table in BigQuery
• How to Query Partitioned Tables Cheaply in BigQuery
• How to Create a View in BigQuery
• How to Insert Data in BigQuery
• How to Use PIVOT in BigQuery
• How to Remove Duplicate Rows in BigQuery
• How to Query Wildcard Tables in BigQuery

Running BigQuery queries as a team? See the SaturnSQL BigQuery editor.