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 dbt March 16, 2026

Your Pipeline Succeeded. Your Data Didn't. - This article details how Nordnet leverages BigQuery’s native ML capabilities and dbt to automate volume anomaly detection across hundreds of tables.

Antigravity BigQuery Gemini March 9, 2026

Decoding GCP Billing with Antigravity and BigQuery MCP - How Google’s agentic IDE and the Model Context Protocol can turn an opaque cloud bill into a granular, custom FinOps CLI in hours.

BigQuery Data Science Paywall March 9, 2026

Materialised Views - BigQuery Materialized Views offer a powerful way to significantly reduce costs and improve query performance by pre-calculating and storing query results as physical data. Unlike standard views, these materialized views eliminate the need to re-run complex queries against raw data, with BigQuery intelligently handling incremental refreshes and even rerouting base table queries for optimal efficiency. This functionality is crucial for optimizing data processing and dashboards, despite some syntax limitations and storage costs.

BigQuery Cloud Spanner Paywall March 9, 2026

Ditching Batch: How to Build a Live Data Pipeline with BigQuery Continuous Queries and Spanner - This article explores how Google Cloud's BigQuery Continuous Queries revolutionize data pipelines by enabling real-time processing of new data directly into Cloud Spanner using simple SQL. This powerful combination allows for immediate analytical insights and high-concurrency transactional reads, effectively moving beyond traditional batch processing for live applications.

BigQuery dbt March 9, 2026

Building a context layer from the ground up - Gorgias built a sophisticated context layer for their internal AI agent, enabling it to accurately answer business questions by generating SQL queries. They unified all data, including unstructured text, within Google Cloud's BigQuery, leveraging its native vector search capabilities. This robust system employs structured metadata and hierarchical instructions to guide the agent in data navigation and understanding, significantly enhancing its reliability and consistency.

AI BigQuery March 2, 2026

BigQuery Graph Series | Part 3: Query and Visualize your Graph - Three part series of articles demonstrates how to effectively query and visualize BigQuery Graphs using the Graph Query Language.

BigQuery FinOps Paywall March 2, 2026

The Query That Cost $500 in 10 Minutes: How I Found Our BigQuery “Slot Eaters” - A Senior Data Engineer’s guide to reducing BigQuery spend by 40% using advanced runtime metrics and partitioned join optimization.

BigQuery MCP Feb. 23, 2026

Getting Started with the BigQuery Remote MCP Server - Connecting your AI tools directly to your data warehouse — no glue code required.

BigQuery MCP Feb. 23, 2026

The Secret Sauce of Reliable AI: Implementing Robust Pre/Post-Processing Hooks - Master the technique of using pre- and post-processing hooks to secure inputs, validate logic, and ensure consistent data use for agents.

BigQuery Generative AI Google Analytics Feb. 23, 2026

Finally, BigQuery can explain its own table relationships! - Google Cloud's BigQuery has introduced a new "Dataset Insights" feature, now in Preview mode, which automatically visualizes and explains table relationships within a dataset. This tool leverages metadata, usage patterns, and AI inference to generate interactive graphs and suggested queries, drastically simplifying the understanding of complex data schemas.

BigQuery Dataform Feb. 23, 2026

5 BigQuery Partitioning Tips you need to know about - This guide provides five essential tips, focusing on how complex query logic or Dataform's `${self()}` injections can lead to inefficient full table scans.

BigQuery LLM Paywall Feb. 23, 2026

BigQuery + Vector Search for Support Tickets: A Practical RAG Pipeline That Survives Real Data Mess - This article details how to construct a practical Retrieval-Augmented Generation (RAG) pipeline for support tickets, specifically designed to handle common data challenges like threads, duplicates, and PII.

BigQuery Data Analytics Official Blog Feb. 23, 2026

New BigQuery global queries let you explore distributed data with a single SQL statement - The preview of global queries in BigQuery lets you query data stored in different geographic locations with a single, standard SQL query, with no ETL.

Agents BigQuery Data Analytics Official Blog Feb. 23, 2026

Building a conversational agent in BigQuery using the Conversational Analytics API - Use the Conversational Analytics API to build context-aware agents that understand natural language, query BigQuery data, and deliver answers in text, tables, and visual charts.

BigQuery Data Analytics Generative AI Feb. 23, 2026

Simplify your AI workflow with autonomous embedding generation in BigQuery - BigQuery autonomous embedding generation treats embeddings as a managed part of your table, making it easier to get your data AI-ready.

BigQuery Cloud Run Gemini Feb. 16, 2026

I Parsed 10,000 Complex Technical Docs for €50: A Multimodal RAG Survival Guide - How I built a practically free, serverless knowledge base on GCP using Gemini 1.5 Flash, BigQuery, Langchain and Cloud Run.

BigQuery Paywall Feb. 16, 2026

BigQuery Materialized Views vs Caching Layers: What Wins on Cost When Traffic Becomes Spiky - A practical cost playbook for handling bursty dashboards and API traffic — without paying for peak all month.

ADK Agents BigQuery Feb. 16, 2026

Using GCP Conversational Analytics (BigQuery) from ADK tools - This article explores various methods for integrating Google Cloud's Conversational Analytics for BigQuery with its Agent Development Kit (ADK) tools. It details three techniques: direct ADK BigQuery tool usage, the MCP Toolbox, and the ADK DataAgent tool, which leverages pre-configured DataAgents for consistent natural language data querying. The discussion highlights the advantages of DataAgents for structured interactions and addresses considerations like chained LLM processing.

BigQuery FinOps Feb. 16, 2026

FinOps: Save Thousands of Dollars a Month on BigQuery with One Command - This article reveals how to significantly reduce Google Cloud BigQuery storage costs by focusing on two key optimization strategies.

BigQuery Paywall Feb. 16, 2026

BigQuery vs DuckDB for JSON: When Semi-Structured Data Is Cheaper Locally Than in Your Warehouse - A practical playbook for picking the right engine for messy JSON — without paying warehouse prices for warehouse convenience.

BigQuery Data Analytics PHP Feb. 16, 2026

How We Halved Latency in PHP with BigQuery Short Query Mode - This article details how an engineering team significantly reduced latency in their PHP applications by optimizing Google BigQuery interactions. This approach resulted in a 50% or more reduction in query times, leading to a substantial improvement in application performance and user experience.

BigQuery Paywall Feb. 9, 2026

BigQuery EXECUTE IMMEDIATE + Templates: Safe Dynamic SQL for Multi-Tenant Analytics - Build flexible, metadata-driven queries per tenant — without turning your warehouse into an SQL-injection playground.

BigQuery Data Science Feb. 9, 2026

BigQuery Merge For Beginners - Learn how to use BigQuery’s MERGE statement to efficiently update existing rows and insert new ones in a single operation.

BigQuery Feb. 9, 2026

The A to Z BigQuery Security: A Battle-Tested Guide for Engineers - BigQuery security is more than just IAM. Learn the architectural patterns for Service Accounts, VPC Service Controls, and Terraform to stop.

BigQuery DevOps Paywall Feb. 9, 2026

I Integrated Agentic AI into our Data Workflow: It’s Not as Easy as the Demos Look - Why 90% of AI Agents Fail the “Production Test” and How I Built the Data Backbone to Save Ours.

BigQuery FinOps Paywall Feb. 2, 2026

Query Labelling - How labels help you explain BigQuery spend and pinpoint cost drivers.

ADK BigQuery Feb. 2, 2026

Building a Reliable AI Analytics Agent with BigQuery, a Semantic Layer, and Google ADK - How to prevent your LLM from confidently giving you the wrong numbers.

BigQuery Paywall Feb. 2, 2026

BigQuery + DuckDB Together: The “Local Hot Cache” Pattern That Slashes Query Bills Without Losing Governance - This article proposes a "local hot cache" pattern using DuckDB alongside BigQuery to significantly reduce query costs. By keeping BigQuery as the governed source of truth and offloading frequently accessed "hot slices" of data to a local DuckDB instance, organizations can avoid expensive repeated scans.

BigQuery dbt Feb. 2, 2026

DBT Migration at Malt - Malt undertook a comprehensive, eight-month migration to transition its custom, in-house data stack to DBT, a standardized data transformation tool. This involved converting their proprietary SQL definitions and schemas, adapting existing Airflow orchestration, and integrating DBT YAML files into their Spark ingestion process.

BigQuery Data Analytics Gemini Official Blog Feb. 2, 2026

BigQuery AI supports Gemini 3.0, simplified embedding generation and new similarity function - BigQuery gen AI functions AI.GENERATE and AI.GENERATE_TABLE are now GA, and can be used with the new AI.EMBED and AI.SIMILARITY.

Showing 181–210 of 2427 resources

 

Latest Issues




Contact

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