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, 2026Eliminate 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, 2026Jev 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, 2026Why 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, 2026Bring Jev to BigQuery with Cloud Run - Turn unstructured text into typed, queryable SQL columns with TypeSafe’s Jev model.
BigQuery dbt Sept. 21, 2026Concurrent 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, 2026Clickstream Data Validation: 5 Ways to Make It Reliable - Based on real clickstream data scenarios from e-commerce and travel platforms.
BigQuery Sept. 21, 2026Arrays 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, 2026How 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, 2026How 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, 2026The $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, 2026From 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, 2026Accelerating 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, 2026Scaling 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, 2026Agent-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, 2026Engineering Agent Observability with BigQuery - Transitioning from Batch Logging to Systems of Action.
AI BigQuery Sept. 14, 2026RAG 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, 2026Bidirectional 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, 2026Serverless 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, 2026Unifying Google Workspace and Apache Iceberg: Serverless Lakehouse Management - Turn Google Sheets into a Petabyte Lakehouse with Sub-Second ACID Queries.
BigQuery Sept. 7, 2026Unifying Google Workspace and Apache Iceberg: Serverless Lakehouse Management
BigQuery Sept. 7, 2026Optimizing 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, 2026What 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, 2026Why 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, 2026BigQuery 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, 2026Simplify 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, 2026Introducing 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, 2026BigQuery 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, 2026How We Use AI to Lower Data Warehouse Query Costs
BigQuery Google Analytics Aug. 31, 2026GA4 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, 2026Tracking 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
Useful Links
Contact
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: [email protected]