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 FinOps Sept. 8, 2025

How to Mix BigQuery On-Demand and Slot Pricing in Practice - Which one is cheaper for what type of workload, and how can you route them on the fly?

BigQuery Paywall Sept. 8, 2025

A Case Statement Tutorial | BigQuery SQL | 2025 - The article provides a comprehensive guide to the CASE statement in BigQuery SQL, highlighting its flexibility in shaping data compared to IF statements.

BigQuery Data Analytics Official Blog Sept. 8, 2025

Introducing BigQuery soft failover: Greater control for disaster recovery testing - Minimize data loss during planned DR activities and ensure business continuity with soft failover in BigQuery Managed Disaster Recovery.

BigQuery Sept. 1, 2025

BigQuery data quality: Automating duplicate record tests in SQL - A guide on how you can automatically detect duplicate records and improve your data quality with a few lines of SQL code.

BigQuery Sept. 1, 2025

Data synchronisation from PostgreSQL to BigQuery (part 2) - A custom data synchronization service from PostgreSQL to BigQuery due to concerns about vendor lock-in, data sovereignty, and the need for flexibility in target systems.

BigQuery Sept. 1, 2025

Now available: Direct Importing from BigQuery to Vector Search - The new BigQuery import feature for Vertex AI Vector Search, now in Public Preview, simplifies data loading by allowing direct import from BigQuery tables, eliminating the need for manual ETL processes.

BigQuery Earth Engine Sept. 1, 2025

A new way to use Earth Engine: Raster analytics and map visualization in BigQuery - Google announces the General Availability of Earth Engine in BigQuery, enhancing geospatial analysis with expanded regional deployment and improved metadata visibility.

BigQuery Cloud Storage FinOps Official Blog Sept. 1, 2025

Storage Insights datasets: How to optimize storage spend with deep visibility - Use Storage Insights datasets and Gemini Cloud Assist to identify which data buckets to relocate and perform large-scale batch operations.

BigQuery Data Analytics Official Blog Sept. 1, 2025

Google Cloud’s open ecosystem for Apache Iceberg - In partnership with Confluent, Databricks, dbt, Fivetran, Informatica and Snowflake, using Apache Iceberg can help dismantle traditional data silos.

BigQuery Serverless Aug. 25, 2025

How to Enable Self Service on Google Cloud - Navigating Agility vs. Governance with Google Cloud’s Serverless Innovations.

AI BigQuery Aug. 25, 2025

Solving Marketing Attribution Mysteries with BigQuery AI - From unstructured data to $434K in revenue insights.

BigQuery Aug. 25, 2025

Automated Data Quality in BigQuery: Autoencoders and PCA - Advanced Anomaly Detection in BigQuery ML Using Autoencoders and PCA for Continuous Data Quality Monitoring.

BigQuery Data Analytics Databricks Official Blog Aug. 25, 2025

Intelligent code conversion: Databricks Spark SQL to BigQuery SQL via Gemini - Automate your Databricks to BigQuery migration. Learn how to use Gemini to translate complex SQL code accurately and save hours of manual work.

ADK AI BigQuery Aug. 18, 2025

ADK Agents for BigQuery Series -Part 4: System Instructions and beyond - Part 4: System Instructions and beyond.

BigQuery Data Analytics GCP Experience Google Cloud Consulting Aug. 18, 2025

From legacy to cloud: How Deutsche Telekom went from PySpark to BigQuery DataFrames - Deutsche Telekom migrated off PySpark to BigQuery DataFrames a.k.a. BigFrames for its distributed Python data processing.

BigQuery FinOps Aug. 11, 2025

BigQuery Cross-Region Replication: Don’t Overlook the Network Costs - Cross region replication involves cost hard to estimate with BigQuery. However, there is a way to approximate egress cost.

BigQuery Cloud Spanner Aug. 11, 2025

From Laggy to Snappy: Accelerating Analytics Insights with Spanner Front-Loading - An architectural pattern for powering scalable, high-concurrency dashboards with BigQuery and Spanner.

BigQuery Dataform dbt Paywall Aug. 11, 2025

Dataform CI/CD sucks. - The article discusses how companies can adapt Dataform to fit their needs when switching to other tools isn't feasible.

ADK AI BigQuery Aug. 11, 2025

ADK Agents for BigQuery Series: Part 1 -Build a BigQuery agent with ADK - The article, part one of a series, introduces building a baseline Natural Language to SQL (NL2SQL) agent for BigQuery using Google's Agent Development Kit (ADK).

AI BigQuery Colab Data Analytics Official Blog Aug. 11, 2025

Announcing AI-first Colab notebook experience for Google Cloud - Introducing Data Science Agent in BigQuery Colab notebooks and Vertex AI Colab Enterprise: Data science and Analytics made simple.

BigQuery Data Analytics Official Blog Aug. 11, 2025

BigQuery under the hood: Short query optimizations in the advanced runtime - BigQuery short query optimizations accelerate small queries by executing them as a single stage. It can significantly improve slot time and latency.

BigQuery Dataplex FinOps Aug. 4, 2025

Deciphering Dataplex Consumption in Google Cloud Billing - This article explains how to understand Dataplex consumption in Google Cloud billing by breaking down charges by workload type using Cloud Billing reports and BigQuery.

BigQuery Gemini Aug. 4, 2025

Building an analytics crew with CrewAI and BigQuery - The article provides a step-by-step guide to building an AI-powered analytics team using CrewAI and Google BigQuery. It details the project structure, agent configuration, task definitions, and the creation of a custom BigQuery tool for data analysis.

BigQuery FinOps GCP Experience Paywall Teradata Aug. 4, 2025

How We Cut BigQuery Costs by 35% During a Teradata-to-GCP Migration - An enterprise migrating from Teradata to GCP reduced BigQuery costs by 35% by implementing detailed billing exports, usage dashboards, and Looker Studio visualizations.

BigQuery Aug. 4, 2025

Pattern Matching with SQL: Real-Time Anomaly Detection Using BigQuery’s MATCH_RECOGNIZE - The article introduces BigQuery's MATCH_RECOGNIZE clause as a powerful SQL tool for behavioral pattern detection, enabling users to identify sequences of events within data.

BigQuery Dataflow Aug. 4, 2025

Mastering BigQuery Default Values with Dataflow - This article explains how to effectively use BigQuery's default value feature with Apache Beam and Dataflow. It details how to configure Dataflow pipelines using FILE_LOADS, STREAMING_INSERTS, and the STORAGE_WRITE_API to trigger BigQuery's default values by omitting columns in the data being written, simplifying ETL logic and delegating data enrichment to BigQuery.

ADK BigQuery Databases Official Blog Aug. 4, 2025

BigQuery meets ADK & MCP: Accelerate agent development with BigQuery's new first-party toolset - Securely connect AI agents to BigQuery. Use ADK and MCP to simplify data access, reducing development overhead and risk. Check out the tutorial.

BigQuery July 28, 2025

Calculating Each Query Job Cost + Storage Cost in BigQuery - This article provides a step-by-step guide to calculating and monitoring BigQuery costs using INFORMATION_SCHEMA views.

Big Data BigQuery July 28, 2025

How to set hard limits on BigQuery costs with custom quota - A practical guide to managing BigQuery costs and setting the right quotas for your project.

BigQuery Cloud Dataproc dbt July 28, 2025

Automating BigQuery Spark Stored Procedures with dbt - This guide shows how to introduce serverless BigQuery Spark stored procedures into your existing dbt project by leveraging dbt macros.

Showing 301–330 of 2427 resources

 

Latest Issues




Contact

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