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 Billing FinOps Sept. 28, 2026

Eliminate First: How We Architected a 60% + BigQuery Cost Reduction - From a struggling MySQL monolith to a high-performance, predictable-cost cloud analytics ecosystem.

AI BigQuery Data Science Machine Learning Sept. 28, 2026

Jev and BigQuery AI functions, from one row to ten million - Testing quality, latency, and cost across Jev and BigQuery’s AI Functions and how combining them in a model cascade gives the best of both.

BigQuery Data Science Sept. 28, 2026

Why I Reworked a BigQuery Sink from Pending Streams to Buffered Streams - This article explains how the Apache SeaTunnel data integration platform redesigned its BigQuery sink connector to improve reliability during failures.

AI BigQuery Cloud Run Data Science Machine Learning Sept. 28, 2026

Bring Jev to BigQuery with Cloud Run - Turn unstructured text into typed, queryable SQL columns with TypeSafe’s Jev model.

BigQuery dbt Sept. 21, 2026

Concurrent Microbatch Support Exists for BigQuery dbt (You’re Welcome) - This article highlights the newly added, yet unannounced, support for dbt’s concurrent microbatch strategy within Google Cloud's BigQuery. It explains how enabling this feature allows data engineers to run large backfill jobs significantly faster by processing multiple incremental batches in parallel.

BigQuery Sept. 21, 2026

Clickstream Data Validation: 5 Ways to Make It Reliable - Based on real clickstream data scenarios from e-commerce and travel platforms.

BigQuery Sept. 21, 2026

Arrays in BigQuery: what they are and how to get data out of them - This article explores how arrays function in Google Cloud's BigQuery, offering a practical guide to handling complex data structures like GA4 exports. It breaks down essential techniques for querying nested data, including using UNNEST, avoiding common pitfalls with SAFE_OFFSET, and leveraging new shorthand functions like ARRAY_FIRST and ARRAY_AGG.

Agents BigQuery Data Analytics Sept. 21, 2026

How to Build a Data Agent in BigQuery Conversational Analytics - This article provides a practical, step-by-step guide to building a custom Data Agent using Google Cloud's BigQuery Conversational Analytics. It covers essential configuration steps—including setting up knowledge sources, business glossaries, and verified queries—to ensure your AI assistant delivers accurate and reliable data insights.

Apache Iceberg BigQuery Sept. 21, 2026

How considering an Iceberg migration made me rethink BigQuery costs — Platforming Data - An evaluation of a potential Apache Iceberg migration revealed unexpected cost and performance trade-offs in Google Cloud's BigQuery, such as faster execution times that paradoxically required higher compute consumption. This discovery prompted a comprehensive reassessment of BigQuery pricing models, prompting a deeper look at how storage billing, query execution, and capacity pricing interact.

BigQuery Data Science Paywall Sept. 21, 2026

The $5,000 GA4 BigQuery Unnesting Mistake: Scalar Subqueries vs. CROSS JOIN - If your Google Cloud bill is exploding, unpacking repeated records before projecting columns is almost certainly the culprit.

Agents BigQuery Sept. 21, 2026

From manual to autonomous: A blueprint for agentic process automation on GCP - This article explores a multi-agent Google Cloud architecture that transforms enterprise customer value management into an autonomous analytics engine capable of delivering actionable insights in minutes.

BigQuery Data Analytics Official Blog Sept. 21, 2026

Accelerating the borderless Lakehouse: Announcing preview of cross-cloud caching - In the borderless Lakehouse, cross-cloud caching reduces data transfers, and BigQuery cross-cloud connections enables querying data in other clouds.

BigQuery Cloud Spanner Data Analytics Databases Official Blog Sept. 21, 2026

Scaling Telco Autonomy: Leveraging GNNs with Distributed GraphFlow - Learn how Distributed GraphFlow scales GNNs for Autonomous Network Operations. Simplify your end-to-end GNN modeling with Google’s new open-source library.

BigQuery Data Analytics Official Blog Sept. 21, 2026

Agent-ready analytics: Unlocking insights with BigQuery augmented analytics - BigQuery augmented analytics Table-Valued Functions (TVFs) automate insight discovery and pattern explanation using AI, ML and statistical methods.

AI BigQuery Data Science Sept. 14, 2026

Engineering Agent Observability with BigQuery - Transitioning from Batch Logging to Systems of Action.

AI BigQuery Sept. 14, 2026

RAG into the Wild: 5 Engines, 5 Truths about your unstructured Data - This article explores how to effectively unlock enterprise unstructured data by benchmarking five different Retrieval-Augmented Generation (RAG) engines on Google Cloud. It details a serverless, event-driven workflow that ingests complex files, generates embeddings, and evaluates performance using Gemini-powered metrics and comparative synthesis.

Apache Iceberg BigQuery Workspace Sept. 14, 2026

Bidirectional Writeback for Apache Iceberg via Google Sheets: Serverless Lakehouse Console - This article explores a serverless, zero-cost architecture that turns Google Sheets into an interactive ACID mutation console for Apache Iceberg on Google Cloud Storage. By combining a Change Data Capture (CDC) engine in Google Apps Script with BigQuery compute, frontline business users can query, edit, and commit data modifications directly back to open lakehouse tables without expensive Reverse ETL SaaS platforms.

Apache Iceberg BigQuery Workspace Sept. 14, 2026

Serverless Multimodal Vector Search on Apache Iceberg via Google Apps Script - This article explores a serverless architecture that combines Google Apps Script, Apache Iceberg, and the Gemini API to build a zero-maintenance multimodal vector search engine. It demonstrates how to ingest and index diverse enterprise assets—such as Google Docs, spreadsheets, binary images, and text notes—into an open Parquet table without needing expensive, dedicated vector databases.

Apache Iceberg BigQuery Workspace Sept. 14, 2026

Unifying Google Workspace and Apache Iceberg: Serverless Lakehouse Management - Turn Google Sheets into a Petabyte Lakehouse with Sub-Second ACID Queries.

BigQuery Sept. 7, 2026

Unifying Google Workspace and Apache Iceberg: Serverless Lakehouse Management

BigQuery Sept. 7, 2026

Optimizing Cost and Performance in BigQuery with Window Functions - Based on real funnel analysis scenarios from e-commerce and travel platforms.

BigQuery Gemini Open Knowledge Format Sept. 7, 2026

What Your Schema Cannot Tell Your Agent, Open Knowledge Format Can - This article discusses the challenges of maintaining AI agent business logic in unstructured prompt strings and introduces Google's Open Knowledge Format (OKF) as a solution. By organizing domain definitions, database schemas, and business rules into version-controlled Markdown files with Git-based reviews, developers can significantly improve the accuracy and reliability of data-driven AI agents.

BigQuery Sept. 7, 2026

Why that subquery in your WHERE clause might be scanning your whole table - This article explains why using an inline subquery in a BigQuery `WHERE` clause can accidentally disable partition pruning and cause your queries to scan an entire table.

BigQuery Sept. 7, 2026

BigQuery Slot Contention Is an Architecture Problem, Not a Query Problem - How to diagnose queueing, workload contention, slot starvation and capacity bottlenecks before rewriting another SQL query.

BigQuery Data Analytics Official Blog Sept. 7, 2026

Simplify pipelines with new BigQuery identity columns - New BigQuery identity columns let you define columns that automatically generate sequential 64-bit integer values to manage’ unique identifiers.

BigQuery Data Analytics Machine Learning Official Blog Sept. 7, 2026

Introducing TabFM in BigQuery: Predictive analytics reimagined - TabFM in BigQuery uses in-context learning (ICL) to deliver highly accurate predictions on your tabular datasets via a single SQL statement.

BigQuery Data Analytics Official Blog Sept. 7, 2026

BigQuery Graph is now GA: the knowledge foundation for the agentic era - Discover how BigQuery Graph enables native graph analytics and AI agent grounding, delivering connected context across enterprise data without moving data.

AI BigQuery FinOps Aug. 31, 2026

How We Use AI to Lower Data Warehouse Query Costs

BigQuery Google Analytics Aug. 31, 2026

GA4 doesn’t send events in the order they happened. But the batch fields will tell you the truth! - When analyzing raw Google Analytics 4 data in BigQuery, simultaneous timestamps can make it difficult to determine the exact order of user actions due to device-level event batching. This article explains how to use three specific GCP export fields—`batch_page_id`, `batch_ordering_id`, and `batch_event_index`—to accurately reconstruct the true sequence of user behavior.

Antigravity BigQuery FinOps Aug. 31, 2026

Tracking Antigravity developer costs with BigQuery - Calculate per-user token costs for Antigravity with Cloud Logging and BigQuery Billing Export.

Showing 31–60 of 2427 resources

 

Latest Issues




Contact

Zdenko Hrček
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: [email protected]