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 Official Blog Feb. 2, 2026BigQuery AI Hackathon: Celebrating Innovation and a Look at What's New - Discover the BigQuery AI Hackathon winners and explore new, powerful SQL-based AI features, including the massive performance update for AI.IF and autonomous embedding generation. Get started today!
BigQuery Data Analytics Generative AI Official Blog Feb. 2, 2026Introducing Conversational Analytics in BigQuery - Conversational Analytics in BigQuery in preview brings a sophisticated AI-powered reasoning engine directly into BigQuery Studio.
BigQuery Data Analytics Datastream Jan. 26, 2026Fixing a Broken PostgreSQL to BigQuery Pipeline Using Google DataStream - A practical guide to setting up CDC replication, troubleshooting common failures, and getting your data flowing again.
BigQuery FinOps Paywall Jan. 26, 2026BigQuery Cost Spikes Explained: Why Your “Small” Change Triggered 10× Spend (and How Pros Prevent It) - This article explains how seemingly small changes in BigQuery queries can trigger significant cost spikes, often by inadvertently increasing bytes processed, data shuffled, or query executions.
BigQuery CI Cloud Build Dataform Jan. 26, 2026Creating a Dataform CI Process using Cloud Build and Github - This article provides a detailed guide on setting up a Continuous Integration (CI) process for Google Cloud Dataform projects using Cloud Build and GitHub.
BigQuery Dataform GCP Experience Jan. 26, 2026We save $8k/Year: Why We Picked BigQuery-native Dataform over dbt Cloud - A guide to scaling data pipelines with Dataform + Airflow for BigQuery teams without a pricey vendor lock-in.
BigQuery Jan. 26, 2026BigQuery’s Managed Inference for Open Models: Your Warehouse is Now an AI Engine - How Google Cloud is democratizing AI inference for data teams — no MLOps expertise required.
BigQuery Dataform Jan. 26, 2026Staying Organized: How to set Schema Name to Parent Folder Name in Dataform - This article demonstrates a method to dynamically set the schema name in Dataform based on the parent folder name, eliminating the need for manual configuration in each action.
BigQuery Cloud Spanner Databases GCP Experience Official Blog Telecommunications Jan. 26, 2026How Fastweb + Vodafone reimagined data workflows with Spanner & BigQuery - Following the acquisition of Vodafone Italy by Swisscom, these European telco leaders saw an opportunity to rethink how they serve customers.
BigQuery FinOps Paywall Jan. 18, 2026BigQuery Table Valuation Functions: Quantify Cost per Query Before You Ship - This article details how to quantify BigQuery query costs *before* deployment using "table valuation" functions and dry runs. This proactive method allows teams to estimate bytes processed and forecast expenses, effectively blocking costly "oops" queries during development.
BigQuery Jan. 18, 2026Building a Medallion Architecture using Apache Iceberg on Google Cloud - This guide explores integrating Apache Spark and Iceberg to build modern data lake architectures within big data environments.
BigQuery Billing FinOps Jan. 18, 2026Querylab.io: No more overspending on BigQuery - Why BigQuery costs get out of control — and how a BigQuery-first IDE fixes that.
BigQuery Jan. 18, 2026Hacking BigQuery — Explicit table locks - Why they are useful and how to implement them on BigQuery.
BigQuery Machine Learning Paywall Jan. 18, 2026BigQuery Product Quantization UDFs: ANN Vector Search at a Fraction of the Cost - This article demonstrates how to achieve approximate nearest neighbor (ANN) vector search in BigQuery at a significantly lower cost. It details implementing Product Quantization (PQ) using User-Defined Functions (UDFs) to compress vectors, enabling a two-stage process of cheap shortlisting followed by precise reranking.
BigQuery Paywall Jan. 18, 2026BigQuery Adaptive Materializations: Auto-Refresh Policies Based on Query Heatmaps - This article details an adaptive strategy for optimizing Google BigQuery materialized views by leveraging query heatmaps derived from job metadata. This approach dynamically tunes refresh policies and max staleness based on actual query patterns and demand, utilizing BigQuery's recommender and user-defined thresholds.
BigQuery Jan. 18, 2026Clean up your BigQuery instance. Delete old tables with BigQuery Cleaner - BigQuery instances can become cluttered with unused tables, leading to confusion and increased storage costs. BigQuery Cleaner is a command-line tool designed to automate the identification and cleanup of these "ghost tables" by analyzing query history to find unreferenced data.
BigQuery Machine Learning Jan. 18, 2026BigQuery as a Feature Store (Without Regret): Cost Controls, Partition Strategy, and Online/Offline Parity - This article provides a practical guide on leveraging BigQuery as a robust offline feature store for machine learning, focusing on mitigating common issues like cost overruns and data inconsistencies.
BigQuery Jan. 18, 2026BigQuery History-Based Optimizations: What Changed - I spent a few weeks chasing a performance issue that turned out not to be a bug, a bad schema, or poorly written SQL.
BigQuery Data Analytics Generative AI Official Blog Jan. 18, 2026Vibe querying: Write SQL queries faster with Comments to SQL in BigQuery - Comments to SQL in BigQuery is an AI-powered feature that bridges the gap between human language and structured data queries. Read to learn more.
BigQuery Data Analytics Generative AI LLM Official Blog Jan. 18, 2026Introducing BigQuery managed and SQL-native inference for open models - BigQuery now supports managed and SQL-native inference for Hugging Face and Vertex AI Model Garden open models.
BigQuery Machine Learning Vertex AI Jan. 12, 2026The Modern Forecasting Stack: From ARIMA to Foundation Models on Google Cloud - A hands-on guide to benchmarking TimesFM, ARIMAX, TiDE, TFT and AutoML across BigQuery and Vertex AI.
BigQuery Jan. 12, 2026Migrate Apache Iceberg tables from Hive Metastore to BigLake Iceberg REST catalog - This article outlines a metadata-only migration process for Apache Iceberg tables, moving them from a Hive Metastore to Google Cloud's BigLake Iceberg REST catalog using serverless Spark in BigQuery Notebooks.
BigQuery Datastream Jan. 12, 2026Datastream Now Supports Native BigQuery Partitioning and Clustering - Google Cloud's Datastream now supports native BigQuery partitioning and clustering, allowing users to define these optimizations directly within the replication workflow.
BigQuery Data Analytics Official Blog Jan. 12, 2026Build data analytics agents faster with BigQuery’s fully managed, remote MCP server - The new fully managed remote BigQuery MCP server makes it easier to build intelligent data AI agents.
BigQuery Paywall Security Jan. 5, 2026BigQuery Tag-Based Governance + Information Schema Audits: Enforce PII Boundaries in SQL - Use policy tags, resource tags, and metadata queries to stop accidental PII leaks — without turning analytics into a permission-ticket queue.
BigQuery Paywall Jan. 5, 2026BigQuery Multi-Project Mesh: Cross-Domain Datasets with Centralized Guardrails - This article details the BigQuery Multi-Project Mesh approach, which enables secure and governed sharing of cross-domain datasets across an organization.
BigQuery Paywall Dec. 29, 2025BigQuery Token-Aware RAG: Hybrid Keyword/Semantic Search with Cost Caps - RAG demos are adorable right up until the first invoice.
BigQuery Data Science Dec. 29, 2025Jumpstart your BigQuery analysis with notebook templates - A guide to the new BigQuery notebook gallery and the top templates for accelerating your data exploration, visualization, and ML workflows.
BigQuery Dec. 29, 2025BigQuery data insights - BigQuery data insights leverages Google's Gemini AI to automatically generate natural language descriptions for data tables and their columns, significantly enhancing data discoverability.
BigQuery Paywall Python Dec. 22, 2025BigQuery + DuckDB Pushdown Planning: Split Queries to Minimize Slot Burn - This article outlines a pragmatic strategy to optimize Google BigQuery costs and performance by reducing "slot burn." It advocates splitting queries, using DuckDB for initial data filtering, shaping, and keyset staging to narrow down datasets.
Showing 211–240 of 2427 resources
Useful Links
Contact
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: [email protected]