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.
AI BigQuery Aug. 31, 2026A year of AI functions in BigQuery: the whole series in one place - This article explores a collection of built-in AI functions that Google Cloud has integrated directly into BigQuery over the past year.
BigQuery Dataform Aug. 24, 2026When to consolidate scheduled queries into Dataform - This article explores the tipping point when managing multiple independent BigQuery scheduled queries becomes unsustainable and transitioning to Google Cloud's Dataform is necessary.
BigQuery FinOps Aug. 24, 2026How to Cut GCP Data Pipeline Costs by 60% Without Slowing Them Down - A practical guide to optimize BigQuery, Dataflow, Cloud Storage, Composer, and the engineering habits around them.
BigQuery dbt Paywall Aug. 24, 2026SCD Type 2 on BigQuery: Stop Rewriting the Partition That Never Changes - This article explores how to optimize Slowly Changing Dimension (SCD) Type 2 tables in Google Cloud BigQuery by rethinking how data is partitioned and updated.
BigQuery Aug. 24, 2026Your BigQuery Bill Is Doing Cardio: A Zero-Data-Loss BigQuery Partitioning Runbook - A production-grade migration strategy for partition pruning, clustering, CDC consistency, validation, rollback, and cost control.
BigQuery Aug. 24, 2026Adding new fields to a nested BigQuery schema: the workaround that actually works - This article explains how to bypass BigQuery's limitation with the `ALTER TABLE` command when trying to add new fields to nested schemas, such as GA4 export tables.
BigQuery Aug. 17, 2026Stop Writing Self-Joins: 14 BigQuery Window Functions Every Data Engineer Should Know - Every self-join you’ve ever written to answer “compared to what?” can probably be deleted. Here’s the replacement.
Apache Beam BigQuery Aug. 17, 2026Apache Beam to BigQuery CDC in Python - This article demonstrates how to implement Change Data Capture (CDC) from an AlloyDB database into Google Cloud BigQuery using Debezium Server, Cloud Pub/Sub, and Apache Beam. It provides a step-by-step guide on capturing database mutations, formatting them with custom metadata schemas, and processing the stream through Google Cloud Dataflow.
Antigravity BigQuery Aug. 17, 2026Stop Flying Blind: Enterprise Observability for Antigravity with Gemini Enterprise - Using Antigravity with Gemini Enterprise.
BigQuery Data Analytics Looker Aug. 17, 2026Implementing dynamic period selection (YTD/MTD) in Looker using Liquid parameters and BigQuery SQL - Dashboards often fall short when users need to constantly request new static views just to switch between YTD and MTD metrics.
BigQuery Generative AI LLM Aug. 17, 2026Future-Proofing Your Vector Search: Swapping Open Source Models in BigQuery with Zero Friction - This article explores how to future-proof vector search workflows by integrating Hugging Face's open-source embedding models directly into Google Cloud's BigQuery using SQL.
AI BigQuery Gemini Aug. 17, 2026BigQuery Is More Than a Warehouse Now. It’s an AI Runtime - BigQuery Can Now Search, Reason, Generate, and Forecast by running AI Directly in SQL.
AI BigQuery Cloud Storage GCP Experience Official Blog Aug. 17, 2026How WPP operationalizes platform and data engineering for AI marketing - WPP built a unified custom platform engineering path, standardizing its serverless compute patterns and data processing workflows.
AI BigQuery Aug. 10, 2026How to Build an Adaptive Feedback Loop for AI Agents in BigQuery - Live RAG remediation and AI agent post-mortems in BigQuery.
Apache Iceberg BigQuery Databricks Aug. 10, 2026Databricks Iceberg — BigQuery query - This article provides a comprehensive technical guide on how to configure and query Apache Iceberg tables created in Databricks (hosted on Google Cloud Platform) using BigQuery. It explains how to set up Google Cloud Storage, Databricks Unity Catalog, and IAM permissions to successfully implement catalog federation between the two platforms. Ultimately, the piece enables data teams to seamlessly read and analyze Databricks-managed Iceberg data directly through Google's cloud-native query engine.
BigQuery Data Analytics Aug. 10, 2026Zero-code, low-cost data ingestion: New BigQuery DTS capabilities - Discover new BigQuery Data Transfer Service capabilities. Automate low-cost data ingestion from diverse sources directly into your data warehouse.
Agents BigQuery Data Analytics Aug. 10, 2026Agentic Future Ready With BigQuery: Continually Improving Price-Performance, Zero Effort - Learn about the latest innovations to help improve BigQuery price-performance with autonomous query processing.
BigQuery dbt FinOps Monitoring Aug. 3, 2026Beyond Monitoring: Extending dbt-bigquery-monitoring into an Data Observability and FinOps Platform - How to transform dbt-bigquery-monitoring from a metadata package into the foundation of an enterprise observability platform for BigQuery.
ADK AI BigQuery BigQueryML Aug. 3, 2026How to Build a Serverless Agent Observability Pipeline in BigQuery - This article demonstrates how to build a real-time, serverless observability pipeline for multi-agent AI systems using the Agent Development Kit, BigQuery Continuous Queries, and BigQuery ML.
BigQuery Data Analytics Aug. 3, 2026Bringing Conversational Analytics to your entire data ecosystem - Get up to speed on the latest for Conversational Analytics (CA) in Google Data Cloud, including BigQuery, Looker and Databases.
BigQuery Data Analytics SAP Aug. 3, 2026Announcing general availability of SAP Business Data Cloud Connect for BigQuery - Unify your operational data in real time. SAP BDC Connect for BigQuery provides a zero-copy architecture to help you lower IT costs.
BigQuery Data Science Terraform July 27, 2026Keep your BigQuery SQL files — let Terraform wire the rest - Avoiding the need to hand-split the code of BigQuery functions, procedures, and views and making Terraform do the heavy work.
BigQuery Generative AI Migration July 27, 2026Agentic Data Platform Migration using Wire, Claude Code and Rittman Analytics - Migrating an entire analytics platform to Google Cloud is a complex, risk-prone undertaking that traditionally involves extensive manual effort to manage and test thousands of interconnected components. This article introduces agentic AI coding tools, specifically Rittman Analytics' Wire Framework leveraging Claude Code, as a solution to automate this process. These tools efficiently audit, translate, and iteratively validate migration items, drastically reducing project timelines and ensuring functional equivalence on the new platform.
BigQuery July 20, 2026How to Evaluate BigQuery Text-to-SQL Models Using Standard Benchmarks - This article introduces EvalBench's Hybrid Execution Accuracy evaluation mode, designed to solve the challenge of assessing BigQuery Text-to-SQL models using SQLite-based standard benchmarks. It overcomes dialect mismatch by executing generated BigQuery queries on BigQuery and original SQLite reference queries on a local fallback, then comparing normalized results.
BigQuery Data Analytics IAM July 20, 2026Level Up Your Column-level Security: Using IAM Data Governance Tags in BigQuery - Learn how to manage column-level access controls in BigQuery using IAM data governance tags, ensuring secure, scalable data classification and protection.
BigQuery Data Analytics Python July 20, 2026Bridging the gap between SQL and Python with BigQuery and the %%bqsql magic - Seamlessly chain Python and SQL in Jupyter notebooks using BigQuery DataFrames and the %%bqsql cell magic. Learn how in this step-by-step guide.
BigQuery Data Analytics Visualization July 20, 2026How to Analyze and Govern Gemini Enterprise App Usage at Scale with BigQuery - Learn how to use BigQuery to analyze Gemini Enterprise usage logs, audit compliance, and build Looker dashboards at scale for your organization.
BigQuery Databases GCP Experience July 20, 2026Building the AI-defined vehicle with Android, Google Cloud, and Nexus SDV - With its Valtech’s Nexus-SDV, Google’s Android and Google Cloud are helping the automotive industry go from the software- to AI-defined vehicle.
BigQuery Machine Learning July 13, 2026E-Commerce Churn Prediction in BigQuery Using TabFM - This article introduces TabFM, a Google Cloud foundation model integrated into BigQuery that enables instant e-commerce churn prediction with zero training. It leverages in-context learning to analyze historical and real-time data directly via SQL, eliminating traditional model development and robustly handling messy datasets. This empowers data analysts to deploy highly accurate predictive models effortlessly.
Big Data BigQuery Paywall July 6, 2026Stop Optimizing BigQuery Until You Run These 5 INFORMATION_SCHEMA Queries - Most BigQuery optimization starts in the wrong place.
Showing 61–90 of 2427 resources
Useful Links
Contact
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: [email protected]