Topic

Google BigQuery

74 articles · 4 guides · 6 videos

QuickBooks to BigQuery: Load the Books and Reconcile Them to the P&LArticle · Google BigQueryQuickBooks to BigQuery: Load the Books and Reconcile Them to the P&LBigQuery aggregate functions: COUNT, SUM, STRING_AGG, ARRAY_AGG and moreArticle · Google BigQueryBigQuery aggregate functions: COUNT, SUM, STRING_AGG, ARRAY_AGG and moreBigQuery SQL style and best practices: a short, tested standardArticle · Google BigQueryBigQuery SQL style and best practices: a short, tested standardBigQuery IF, CASE, IFNULL, NULLIF and COALESCE, with tested examplesArticle · Google BigQueryBigQuery IF, CASE, IFNULL, NULLIF and COALESCE, with tested examplesBigQuery CREATE TABLE and DROP TABLE: syntax and examplesArticle · Google BigQueryBigQuery CREATE TABLE and DROP TABLE: syntax and examplesHow to create a view in BigQuery: CREATE VIEW, cost and limitsArticle · Google BigQueryHow to create a view in BigQuery: CREATE VIEW, cost and limitsBigQuery CTE: WITH clauses and recursive CTEs, with tested examplesArticle · Google BigQueryBigQuery CTE: WITH clauses and recursive CTEs, with tested examplesBigQuery DML: INSERT, UPDATE, DELETE and MERGE with tested examplesArticle · Google BigQueryBigQuery DML: INSERT, UPDATE, DELETE and MERGE with tested examplesBigQuery IAM roles: which one to grant, and how to share a datasetArticle · Google BigQueryBigQuery IAM roles: which one to grant, and how to share a datasetBigQuery JSON functions: the JSON type, JSON_SET, JSON_REMOVE and moreArticle · Google BigQueryBigQuery JSON functions: the JSON type, JSON_SET, JSON_REMOVE and moreBigQuery JSON arrays and objects: JSON_QUERY_ARRAY, UNNEST and JSON_OBJECTArticle · Google BigQueryBigQuery JSON arrays and objects: JSON_QUERY_ARRAY, UNNEST and JSON_OBJECTBigQuery materialized views: when they help, limits and refreshArticle · Google BigQueryBigQuery materialized views: when they help, limits and refreshBigQuery math functions: ROUND, SAFE_DIVIDE, MOD, POW and moreArticle · Google BigQueryBigQuery math functions: ROUND, SAFE_DIVIDE, MOD, POW and moreBigQuery navigation functions: LAG, LEAD, LAST_VALUE and PERCENTILE_CONTArticle · Google BigQueryBigQuery navigation functions: LAG, LEAD, LAST_VALUE and PERCENTILE_CONTBigQuery updates for analysts: what changed in 2025 and 2026Article · Google BigQueryBigQuery updates for analysts: what changed in 2025 and 2026BigQuery ROW_NUMBER, RANK, DENSE_RANK and NTILE, with tested examplesArticle · Google BigQueryBigQuery ROW_NUMBER, RANK, DENSE_RANK and NTILE, with tested examplesBigQuery geography functions: points, distances, polygons and BigQuery MLArticle · Google BigQueryBigQuery geography functions: points, distances, polygons and BigQuery MLBigQuery public datasets: how to find, query and pay for themArticle · Google BigQueryBigQuery public datasets: how to find, query and pay for themBigQuery sandbox: free limits, setup and what happens when you upgradeArticle · Google BigQueryBigQuery sandbox: free limits, setup and what happens when you upgradeBigQuery SQL: syntax, clause order and tested examplesArticle · Google BigQueryBigQuery SQL: syntax, clause order and tested examplesBigQuery statistical aggregate functions: STDDEV, VARIANCE, CORR and medianArticle · Google BigQueryBigQuery statistical aggregate functions: STDDEV, VARIANCE, CORR and medianBigQuery table explorer and data insights: what changed, and the SQL to profile a table yourselfArticle · Google BigQueryBigQuery table explorer and data insights: what changed, and the SQL to profile a table yourselfBigQuery time travel: FOR SYSTEM_TIME AS OF, the window and examplesArticle · Google BigQueryBigQuery time travel: FOR SYSTEM_TIME AS OF, the window and examplesBigQuery export to CSV: query results, tables, Sheets and ExcelArticle · Google BigQueryBigQuery export to CSV: query results, tables, Sheets and ExcelBigQuery data types: which to use, with limits and tested examplesArticle · Google BigQueryBigQuery data types: which to use, with limits and tested examplesBigQuery console guide: BigQuery Studio, the query editor and job historyArticle · Google BigQueryBigQuery console guide: BigQuery Studio, the query editor and job historyBigQuery visualization tools: Data Studio, Looker, Sheets, Power BI, Tableau and Excel comparedArticle · Google BigQueryBigQuery visualization tools: Data Studio, Looker, Sheets, Power BI, Tableau and Excel comparedBigQuery wildcard tables and _TABLE_SUFFIX, with measured costsArticle · Google BigQueryBigQuery wildcard tables and _TABLE_SUFFIX, with measured costsBigQuery window functions: OVER, PARTITION BY, frames and LAG, with examplesArticle · Google BigQueryBigQuery window functions: OVER, PARTITION BY, frames and LAG, with examplesGA4 user properties in BigQuery: user_id, user_pseudo_id, first touch and LTVArticle · Google BigQueryGA4 user properties in BigQuery: user_id, user_pseudo_id, first touch and LTVGA4 BigQuery dashboard in Data Studio: a flat daily table, not events_*Article · Google BigQueryGA4 BigQuery dashboard in Data Studio: a flat daily table, not events_*GA4 BigQuery Export schema: the tables, the fields and how dates workArticle · Google BigQueryGA4 BigQuery Export schema: the tables, the fields and how dates workGA4 BigQuery Export mistakes: nine that change your numbers, and the fix for eachArticle · Google BigQueryGA4 BigQuery Export mistakes: nine that change your numbers, and the fix for eachHow to query GA4 event data in BigQuery: sessions, sources and revenueArticle · Google BigQueryHow to query GA4 event data in BigQuery: sessions, sources and revenueHow to unnest GA4 event_params in BigQuery: page_location, ga_session_id and itemsArticle · Google BigQueryHow to unnest GA4 event_params in BigQuery: page_location, ga_session_id and itemsBigQuery MCP for Claude: connect it, see every query, check every numberArticle · Google BigQueryBigQuery MCP for Claude: connect it, see every query, check every numberSnowflake vs BigQuery: A detailed comparisonArticle · Google BigQuerySnowflake vs BigQuery: A detailed comparisonHow to connect BigQuery to Excel: four ways that workArticle · Google BigQueryHow to connect BigQuery to Excel: four ways that workBigQuery query examples: six sample queries you can run on GA4 dataArticle · Google BigQueryBigQuery query examples: six sample queries you can run on GA4 dataHow to connect BigQuery to Looker Studio and automate your reportsArticle · Google BigQueryHow to connect BigQuery to Looker Studio and automate your reportsBigQuery schema: how to specify, view and change a table schemaArticle · Google BigQueryBigQuery schema: how to specify, view and change a table schemaHow to connect Google Sheets to BigQuery: three waysArticle · Google BigQueryHow to connect Google Sheets to BigQuery: three waysGoogle Ads to BigQuery: two ways to connect them, step by stepArticle · Google BigQueryGoogle Ads to BigQuery: two ways to connect them, step by stepBigQuery functions: a map of the main families, with examplesArticle · Google BigQueryBigQuery functions: a map of the main families, with examplesBigQuery standard SQL vs legacy SQL: what changed and how to switchArticle · Google BigQueryBigQuery standard SQL vs legacy SQL: what changed and how to switchHow to restore a deleted table in BigQuery, and back up your dataArticle · Google BigQueryHow to restore a deleted table in BigQuery, and back up your dataBigQuery array functions: syntax and tested examplesArticle · Google BigQueryBigQuery array functions: syntax and tested examplesBigQuery CAST and SAFE_CAST: convert data types without errorsArticle · Google BigQueryBigQuery CAST and SAFE_CAST: convert data types without errorsBigQuery conversion functions: every type-to-type conversionArticle · Google BigQueryBigQuery conversion functions: every type-to-type conversionBigQuery date functions: syntax, examples and common errorsArticle · Google BigQueryBigQuery date functions: syntax, examples and common errorsDATE vs DATETIME vs TIMESTAMP: how to choose the right SQL date typeArticle · Google BigQueryDATE vs DATETIME vs TIMESTAMP: how to choose the right SQL date typeBigQuery datetime functions: syntax and tested examplesArticle · Google BigQueryBigQuery datetime functions: syntax and tested examplesWhat is Google BigQuery: how it works, costs and where to startArticle · Google BigQueryWhat is Google BigQuery: how it works, costs and where to startJOIN vs UNION in SQL: the difference, with examplesArticle · Google BigQueryJOIN vs UNION in SQL: the difference, with examplesBigQuery JSON functions: JSON_VALUE, JSON_QUERY and PARSE_JSON explainedArticle · Google BigQueryBigQuery JSON functions: JSON_VALUE, JSON_QUERY and PARSE_JSON explainedBigQuery ML: what it is, model types and a working exampleArticle · Google BigQueryBigQuery ML: what it is, model types and a working exampleBigQuery ALTER TABLE: add, rename and drop columns, change data typesArticle · Google BigQueryBigQuery ALTER TABLE: add, rename and drop columns, change data typesBigQuery partitioned tables: how to create, query and manage themArticle · Google BigQueryBigQuery partitioned tables: how to create, query and manage themBigQuery pricing: what queries and storage cost, with examplesArticle · Google BigQueryBigQuery pricing: what queries and storage cost, with examplesBigQuery query history: how to find, query and audit past jobsArticle · Google BigQueryBigQuery query history: how to find, query and audit past jobsHow to connect BigQuery to Google Sheets: three waysArticle · Google BigQueryHow to connect BigQuery to Google Sheets: three waysWHERE vs HAVING vs QUALIFY: SQL filter clauses explainedArticle · Google BigQueryWHERE vs HAVING vs QUALIFY: SQL filter clauses explainedBigQuery timestamp functions: syntax and tested examplesArticle · Google BigQueryBigQuery timestamp functions: syntax and tested examplesCOALESCE in BigQuery: syntax, examples and common mistakesArticle · Google BigQueryCOALESCE in BigQuery: syntax, examples and common mistakesHow to connect GA4 to BigQuery: setup, limits and first queriesArticle · Google BigQueryHow to connect GA4 to BigQuery: setup, limits and first queriesGoogle Search Console to BigQuery: bulk data export setup and SQLArticle · Google BigQueryGoogle Search Console to BigQuery: bulk data export setup and SQLHow to load data into BigQuery: every method and when to use itArticle · Google BigQueryHow to load data into BigQuery: every method and when to use itBigQuery string functions: syntax and tested examplesArticle · Google BigQueryBigQuery string functions: syntax and tested examplesHow to upload data to BigQuery: CSV, Google Drive and SQLArticle · Google BigQueryHow to upload data to BigQuery: CSV, Google Drive and SQLIs BigQuery a data warehouse or a data lake? A guide for marketing teamsArticle · Google BigQueryIs BigQuery a data warehouse or a data lake? A guide for marketing teamsBigQuery for marketing analytics: What changed in 2026Article · Google BigQueryBigQuery for marketing analytics: What changed in 2026Google Sheets to BigQuery: How to scale your analyst workflow without buying new toolsArticle · Google BigQueryGoogle Sheets to BigQuery: How to scale your analyst workflow without buying new toolsHow to build a free modern analytics stack with JavaScript, SQL, BigQuery & OWOXArticle · Google BigQueryHow to build a free modern analytics stack with JavaScript, SQL, BigQuery & OWOXWhy you should store your BigQuery SQL for Looker Studio in OWOX Data MartsArticle · Google BigQueryWhy you should store your BigQuery SQL for Looker Studio in OWOX Data Marts

Guides

Manage & Predict BigQuery Costs with OWOXGuide · Google BigQueryManage & Predict BigQuery Costs with OWOXSQL Queries to Google BigQuery DataGuide · Google BigQuerySQL Queries to Google BigQuery DataHow to Control and Optimize Costs for Google BigQueryGuide · Google BigQueryHow to Control and Optimize Costs for Google BigQueryHow to Set up GA4 BigQuery Export: Step-by-Step GuideGuide · Google BigQueryHow to Set up GA4 BigQuery Export: Step-by-Step Guide

Videos

OWOX: Reports, Charts & PivotsVideo · Google BigQueryOWOX: Reports, Charts & PivotsHow to Connect BigQuery to Google Sheets: Top 3 Ways to Import DataVideo · Google BigQueryHow to Connect BigQuery to Google Sheets: Top 3 Ways to Import DataHow to Build a GA4 User Acquisition Standard Report in BigQueryVideo · Google BigQueryHow to Build a GA4 User Acquisition Standard Report in BigQueryGA4 Events Data Schema in BigQuery | Marketing Analytics for BeginnersVideo · Google BigQueryGA4 Events Data Schema in BigQuery | Marketing Analytics for BeginnersHow to Query GA4 Event Data in BigQuery | Marketing Analytics for BeginnersVideo · Google BigQueryHow to Query GA4 Event Data in BigQuery | Marketing Analytics for Beginners8 Reasons to Export GA4 Data to BigQuery | Marketing Analytics for BeginnersVideo · Google BigQuery8 Reasons to Export GA4 Data to BigQuery | Marketing Analytics for Beginners