Tag: BigQuery
Resources about BigQuery collected from the weekly GCP Weekly newsletter — a hand-curated collection of Google Cloud Platform news, technical articles, tutorials, videos and release notes. Each entry below links back to the original GCP Weekly issue and retains its publish date and title, giving you a focused, searchable knowledge base for this topic.
BigQuery Data Analytics July 28, 2025Optimize Ad Verification Logging with Google Cloud BigQuery: How We Achieved Success - DoubleVerify migrated its ad verification logging from a legacy on-premise OLAP system to Google Cloud BigQuery to handle increasing data volumes and enable advanced analytics.
BigQuery Data Analytics July 28, 2025BigQuery Advanced Runtime: Testing Performance Part 2 - The article analyzes the performance impact of clustering in BigQuery's Advanced Runtime. Findings show that clustering significantly improves performance for selective queries by reducing I/O, although some queries may experience degraded performance due to query optimizer issues.
BigQuery July 21, 2025The Conditional Array Cross-Join Pattern in SQL - The article explains a SQL pattern for dynamically generating rows based on conditions in BigQuery. It uses CROSS JOIN UNNEST, STRUCT arrays, and conditional array concatenation. This pattern helps in scenarios like event logging, multi-step tracking, and financial reporting.
BigQuery July 21, 2025This is Multimodal Analytics - BigQuery’s ObjectRef Explained (For Humans).
BigQuery FinOps July 21, 202550%+ cost reduction by changing how we get table’s partition in dbt - Small improvement for dbt + BigQuery’s cost-saving measures.
BigQuery July 21, 2025The Wall Between Structured and Unstructured Data Just Crumbled - Google BigQuery's new ObjectRef feature bridges the gap between structured and unstructured data by allowing users to store references to files like images and audio within SQL tables.
BigQuery Cloud Functions Python July 21, 2025Parallelizing BigQuery Stored Procedures with Google Cloud Functions - A case study in squeezing speed out of serverless stored procedures in BigQuery.
BigQuery Cloud Dataproc Cloud Run Serverless Spark July 14, 2025Submitting a PySpark Job to Serverless Dataproc from a Cloud Run Function - The article discusses how to submit PySpark jobs to Serverless Dataproc from a Python-based Cloud Run function for scalable batch processing on Google Cloud.
AI BigQuery Security July 14, 2025BigQuery meets ADK: 10 tips to safeguard your data (and wallet) from agents - The article provides ten tips for safeguarding data and managing costs when using agents with BigQuery and ADK, including explicit system instructions, callbacks, SQL parameterization etc.
BigQuery Data Analytics GCP Experience Official Blog July 14, 2025This migration from Snowflake to BigQuery accelerated model building and cut costs in half - SmarterX’s migration also helped unify its tech stack and accelerated model building.
BigQuery Data Analytics Official Blog July 14, 2025Beyond GROUP BY: Introducing advanced aggregation functions in BigQuery - BigQuery has three new categories of advanced aggregation functions: group by extensions, user-defined and approximate aggregate functions.
BigQuery Data Analytics Official Blog July 14, 2025SQL reimagined: How pipe syntax is powering real-world use cases - Learn how organizations are using pipe syntax, an extension to GoogleSQL, to streamline data transformations, build reports, and analyze logs.
BigQuery July 7, 2025Why Are My BigQuery Storage Costs Over Budget? - Written By: Anbu Cheeralan.
BigQuery Gemini July 7, 2025Leverage BigQuery’s Analytical Prowess with the Gemini CLI and MCP Toolbox (Part 1) - Access Google Cloud’s largest data analytic service directly from your terminal!
BigQuery July 7, 2025BigQuery vs Clickhouse — How we decided - Learn how Userbird evaluated BigQuery vs Clickhouse as our time series database.
BigQuery Databricks July 7, 2025Migrating Databricks to BigQuery: Delta Sharing & Spark Procedure - The article explores using Databricks Delta Sharing with BigQuery Spark Procedures for efficient data migration from Databricks to Google BigQuery.
BigQuery July 7, 2025BigQuery Advanced Runtime: Testing Performance - BigQuery's Advanced Runtime, enabled via an ALTER PROJECT command, boosts query performance by approximately 30% and reduces compute costs by 32% through enhanced vectorization. The new runtime requires no code changes and provides immediate improvements, making it beneficial for users seeking faster queries and reduced resource consumption, regardless of pricing model.
BigQuery July 7, 2025BigQuery On Steroids: 21x Performance Boost With Vectorized Execution - Google Cloud's BigQuery advanced runtime, now in preview, enhances query performance through improved vectorization and encoding techniques. Benchmarks demonstrate significant speed improvements, up to 21x, by processing data in chunks and optimizing data storage.
BigQuery Google Analytics June 30, 2025How to build a custom user journey GA4 report in BigQuery - Learn how to build a custom user journey report in GA4 using BigQuery! Step-by-step guide to analyze customer paths, optimize conversions.
BigQuery Data Analytics Generative AI June 30, 2025Unlock Insights Faster: Meet Your AI Assistant in BigQuery Data Canvas! - This post is a joint collaboration with Blessing Bamiduro (PM, DB & Analytics, Google Cloud).
BigQuery June 30, 2025Source-Agnostic Data Ingestion with Singer and Meltano on GCP - Build a declarative ETL pipeline and load any data to BigQuery with an open source solution.
BigQuery Streaming June 30, 2025Why Adding a LIMIT to a SORT in BigQuery Improves Performance — And What It Teaches Us About Efficient Sorting - As a GCP trainer, I recently got a fascinating question:.
BigQuery June 30, 2025How to Update the Schema of an Incremental BigQuery Table - Learn how to add new fields to RECORD (STRUCT) columns in BigQuery table schemas without breaking your incremental data pipeline.
BigQuery Data Analytics Official Blog June 30, 2025Introducing BigQuery ObjectRef: Supercharge your multimodal data and AI processing - The new ObjectRef data type helps to integrate unstructured data like images and audio into existing BigQuery tables.
BigQuery FinOps June 23, 2025BigQuery time-partitioning: The hidden cost trap - How choosing the wrong date function can explode your BigQuery costs.
BigQuery Billing FinOps Paywall June 23, 2025BigQuery Cost Management and Monitoring: In-Depth Technical Guide - BigQuery cost management is crucial as usage grows. The article provides techniques like table partitioning, query optimization, and audit log analysis. It also highlights the importance of understanding storage costs, including active and long-term storage, to control spending and maintain performance.
BigQuery Paywall June 23, 2025Why My BigQuery Query Was Fast at 10K Rows and Died at 10M - The article discusses common mistakes when using BigQuery that can lead to performance issues when scaling from small test datasets to larger, real-world datasets.
BigQuery Data Analytics Official Blog June 23, 2025BigQuery under the hood: Enhanced vectorization in the advanced runtime - BigQuery applies enhanced vectorization to aspects of query processing such as filter evaluation and data encodings and optimization techniques.
AI BigQuery June 16, 2025The SQL Fanatics’ Dream: AI Agents Without the Application Code! - The article discusses how BigQuery allows users to build applications with search and chat functionalities using only SQL queries, eliminating the need for extensive application code.
Airflow BigQuery dbt June 16, 2025Advanced Security Strategies for Data Pipelines with Airflow, dbt, and BigQuery on GCP - Protect your data pipelines beyond access controls: learn deep security techniques for Airflow, dbt, and BigQuery in a modern GCP stack.
Showing 331–360 of 2427 resources
Useful Links
Contact
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: [email protected]