Blog

OWOX Blog

1077 pieces, newest first

BigQuery 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 examples

…