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 Cloud Spanner Data Analytics Databases Official Blog April 20, 2026From operational to analytical: The unified Spanner Graph and BigQuery Graph solution - A unified operational and analytical solution with Spanner Graph and BigQuery Graph that minimizes data movements without compromising performance.
BigQuery Data Analytics Databases Official Blog April 20, 2026Introducing BigQuery Graph: Unlock hidden relationships in your data - BigQuery Graph lets data professionals model, analyze and visualize massive-scale relationships in an entirely new way.
BigQuery Data Analytics Official Blog April 20, 2026Go from blank slate to analysis with BigQuery Studio notebook gallery templates - Templates in BigQuery Studio notebook gallery, now GA, help you bypass the setup phase and jump straight into discovery.
BigQuery April 13, 2026The Practical Guide to BigQuery Graph: Resources, Codelabs, and GQL Examples - Google Cloud's new BigQuery Graph allows for native modeling and analysis of complex relationships directly within BigQuery, leveraging Graph Query Language (GQL) and SQL/PGQ standards. The article provides a comprehensive guide with resources, hands-on codelabs, and practical GQL examples to help users master this powerful capability.
BigQuery Looker Paywall April 13, 2026The Discipline of Data: A Complete Guide to Looker and LookML - From first principles to production-grade practice — for engineers who know SQL and are ready to build systems that outlast them.
BigQuery Data Science April 13, 2026AI Functions in BigQuery Dataframes - Google Cloud's BigFrames introduces AI functions to bridge the gap between traditional dataframes and Generative AI workflows. This enables easy integration of Gemini-powered insights, moving beyond manual looping for complex AI analyses.
AI BigQuery MCP April 13, 2026Is MCP dead? 2025 vs 2026 at GCP Next - Analysis of Google Cloud Next session catalogs reveals a substantial increase in "MCP" related content from 2025 to 2026, signaling Google's shift towards an AI agent execution stack.
Apache Iceberg BigQuery Data Analytics Official Blog April 13, 2026Openness without compromises for your Apache Iceberg lakehouse - Apache Iceberg tables in Google-managed Iceberg REST Catalog provides read and write interoperability between BigQuery and Iceberg-compatible engines.
ADK Agents BigQuery Cloud Pub/Sub Official Blog April 13, 2026Building Event-Driven Data Agents with BigQuery, Pub/Sub, and ADK - Build real-time, autonomous AI agents to detect and resolve anomalies on Google Cloud. Combine BigQuery continuous queries, Pub/Sub routing, and Vertex AI Agent Engine (ADK) to instantly act on data.
BigQuery Cloud Dataproc Python April 6, 2026When SQL Hits the Wall: Migrating Vehicle Analytics from BigQuery to PySpark - A 10M-row dataset, SQL’s limits, and a migration to PySpark on Dataproc.
AI BigQuery Cloud Pub/Sub April 6, 2026Real-time Intelligent Triage Engine with BigQuery Continuous Queries - This article demonstrates how to build a real-time intelligent triage engine using Google Cloud's BigQuery Continuous Queries, Vertex AI (Gemini), and Pub/Sub.
BigQuery Security April 6, 2026Row-Level & Column-Level Security in BigQuery : A comprehensive guide to fine-grained data access control - This guide explores Google BigQuery's Row-Level Security (RLS) and Column-Level Security (CLS), offering a comprehensive solution for fine-grained data access control. RLS allows administrators to restrict which rows a user can see, while CLS controls access to specific columns or masks their values. These features integrate seamlessly with Google IAM, eliminating the need for data duplication and simplifying data governance within a single BigQuery table.
BigQuery Paywall March 30, 2026All You Need to Know About Securing Sensitive Data in BigQuery: Encryption, Masking, and Best Practices - A Practical Guide to Protecting Your Data with GCP Tools and Techniques.
BigQuery March 30, 2026Stop Searching, Start Reading: Building a Hybrid Macro-to-Micro RAG Pipeline on BigQuery - How sequential vector + vectorless retrieval achieves both massive scale and reasoning-level precision — with SQL you can run today.
AI BigQuery Data Analytics Machine Learning March 30, 2026How I Finally Killed My Massive BigQuery CASE Statements - Clean up your data with AI.SIMILARITY and AI.EMBED.
BigQuery March 30, 2026What Enterprise Data Engineering Actually Looks Like (vs What I Expected) - After 1.5 years building production pipelines at a Fortune Global 500 company, here’s what I wish someone had told me.
BigQuery March 23, 2026How I Reduced BigQuery Pipeline Failures from 20 per Day to Zero Using Exponential Retries 🚀 - Anyone who has managed cloud data pipelines knows this universal truth:.
Big Data BigQuery Paywall March 23, 2026Spark on GCP is Overkill — Use BigQuery Instead - When BigQuery beats Spark — and when it doesn’t.
BigQuery March 23, 2026BigQuery Added Pipe Syntax. Most Teams Haven’t Switched Yet. Here’s Why They Should. - BigQuery introduced a new pipe syntax in 2024 to address the mental overhead and debugging challenges of traditional SQL, offering a more intuitive, sequential approach to data transformation. While it significantly improves debugging by allowing incremental query execution, widespread adoption is hindered by a lack of compatible tooling. Specialized editors are crucial for teams to fully leverage this syntax for cleaner, faster-to-debug queries.
ADK BigQuery Cloud Run March 23, 2026End-to-End AI Agent on GCP: ADK, BigQuery MCP, Agent Engine, and Cloud Run - This article demonstrates building an end-to-end AI agent on Google Cloud, showcasing a football statistics assistant using Google's Agent Development Kit (ADK). It details connecting to BigQuery via Cloud API Registry for data and explores deployment options like Cloud Run or Vertex AI Agent Engine, complete with robust CI/CD.
BigQuery dbt March 23, 2026Data Modeling: Best Practices with BigQuery and dbt - An opinionated guide to Data Modeling.
BigQuery Data Science March 23, 2026Why Your BigQuery Queries Just Got Faster - Understanding the rollout of BigQuery’s advanced runtime.
BigQuery Data Analytics Gemini Official Blog March 23, 2026BigQuery Studio is more useful than ever, with enhanced Gemini assistant - BigQuery Studio’s latest Gemini-powered assistant goes from being a code assistant into a fully context-aware analytics partner.
Apache Beam BigQuery Cloud Dataflow March 16, 2026Debugging Broken Streaming Pipelines: A Data Engineer’s Survival Guide - For an enterprise data engineer, the most frustrating pager alert is often the one you never receive.
BigQuery March 16, 2026Auditing BigQuery Access Across a GCP Organization - Auditing BigQuery access across a Google Cloud organization is challenging because native tools provide fragmented views. This article introduces `bq-discovery`, a Python CLI tool that unifies Cloud Asset Inventory, BigQuery dataset metadata, and Cloud Identity to create a single, normalized, and queryable inventory of BigQuery permissions. This solution allows for comprehensive access analysis and auditing by consolidating all relevant access paths into one dataset.
BigQuery FinOps March 16, 2026Decoding BigQuery capacity commitments and CUDs - This article delves into Google Cloud BigQuery's capacity commitments and Committed Use Discounts (CUDs), explaining their evolution and how they impact cost optimization. It highlights that while commitments offer predictability, they can lead to unexpected costs if workload patterns aren't consistently stable.
BigQuery March 16, 2026BigQuery pipe syntax by example - SQL faster to write and far easier to maintain.
BigQuery Google Analytics March 16, 2026So You Think You’re a BigQuery Power User - This article unveils several powerful, often-overlooked features in BigQuery's GoogleSQL that significantly streamline query writing. It demonstrates how new syntaxes, such as `GROUP BY ALL`, `UNION ALL BY NAME`, chained function calls, and `ANY_VALUE(x HAVING MAX y)`, make queries more readable, concise, and efficient for modern SQL development.
ADK BigQuery Machine Learning Networking Telecommunications March 16, 2026Stream processing with BigQuery STATEFUL continuous queries and ADK agents for Telco network monitoring - This article outlines an automated pipeline for Telco network monitoring and self-healing, designed to address dynamic user demand on static infrastructure. It leverages BigQuery's stateful continuous queries for real-time anomaly detection and Pub/Sub to trigger AI agents (ADK) for intelligent network reconfiguration.
BigQuery Data Science Paywall March 16, 2026Temp Tables and Session Mode - This article explains how using BigQuery's temporary tables in conjunction with session mode can significantly reduce query costs. By materializing filtered data subsets into temporary tables that persist within a session, users can avoid repeatedly processing large datasets. This approach offers substantial cost savings and improved efficiency for analysts and engineers performing iterative or multi-step queries.
Showing 151–180 of 2427 resources
Useful Links
Contact
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: [email protected]