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 Data Analytics Dataplex Official Blog Oct. 27, 2025

Build trust and context for AI with lineage, now at column-level granularity - Dataplex column-level lineage in BigQuery charts a data column’s path as it moves, establishing context for agentic AI applications.

BigQuery Paywall Oct. 20, 2025

Vector SQL in Practice: Embedding Tables, ANN vs. Exact Search - BigQuery supports vector search, enabling users to store and query embeddings with SQL, choosing between exact brute-force search and fast ANN indexes. The article provides a practical guide covering table design, distance metrics, index choices (IVF, TreeAH/ScaNN), pre/post-filters, cost optimization, and testing strategies for production use.

BigQuery FinOps Paywall Oct. 20, 2025

BigQuery Slots vs On-Demand: Choose with Math - A clear, numbers-first way to pick the right BigQuery pricing model — without vibes or guesswork.

BigQuery Paywall Python Oct. 20, 2025

8 BigQuery Tricks from Python - Faster reads, safer writes, and cheaper queries using pandas-gbq, DB-API, and Arrow—without fighting dtypes or paying surprise bills.

BigQuery Data Analytics Official Blog Oct. 20, 2025

Secure data collaboration with query templates in BigQuery data clean rooms - Query templates in BigQuery data clean rooms let you create pre-defined queries that run against specific tables, reducing the risk of data exfiltration.

BigQuery Data Analytics Official Blog Oct. 20, 2025

New BigQuery Studio experience: Boost your data analysis productivity - BigQuery Studio’s improved console interface helps streamline your workflows, enhances your productivity, and gives you greater control.

BigQuery Dataplex Oct. 13, 2025

A Practical Guide to Custom Lineage with Google’s Data Lineage API - The article discusses how Google Cloud's Data Lineage API can be used to enhance data governance by mapping data flows from custom scripts and legacy systems, areas often missed by automated tools.

BigQuery Data Science Oct. 13, 2025

Timedelta in BigFrames - The article demonstrates how BigFrames supports timedelta operations, bridging the gap between Pandas API and BigQuery, and represents timedelta values.

BigQuery dbt Javascript Oct. 6, 2025

DBT and BigQuery JavaScript UDF (or Python): How to create, deploy it and add library from GCS. - This article explains how to create and deploy BigQuery User-Defined Functions using DBT, including incorporating JavaScript libraries from Google Cloud Storage. It outlines three methods: inline JavaScript, minified JavaScript libraries, and libraries stored in GCS, and provides a CI/CD script for syncing libraries.

BigQuery Paywall Oct. 6, 2025

10 Cost-Smart Ways to Export Pandas → BigQuery - Practical patterns to move DataFrames into BigQuery without surprise bills — fast paths, right file formats, and safe upserts.

BigQuery Paywall Oct. 6, 2025

Data Types | BigQuery Cost Reduction Tier List Series | A Tier - How Data Type Choices Affect Query Speed and Storage Costs.

BigQuery Data Analytics Official Blog Oct. 6, 2025

Converse with your data and generate forecasts using BigQuery's new MCP and ADK tools - “Ask data insights” for Conversational Analytics and the BigQuery Forecast for time-series predictions tools use AI for data analysis and predictions.

BI Engine BigQuery Paywall Sept. 29, 2025

I Flipped a Switch in BigQuery and My Queries Got 75% Faster for Free - The Advanced Runtime is the next evolution of this powerhouse engine — a complete modernization of its core technology.

BigQuery FinOps Sept. 29, 2025

Build a GCP Cost Agent with ADK and MCP Toolbox for Databases to Analyze Your Cloud Spending - The article introduces a GCP Cost Agent built using the Agent Development Kit (ADK) and MCP Toolbox for Databases. It allows users to analyze Google Cloud spending data in BigQuery through conversational queries, eliminating the need for complex SQL or console navigation. The agent provides insights into total costs, project breakdowns, and service expenses, streamlining FinOps workflows and making cloud cost management more accessible.

BigQuery Sept. 29, 2025

When to Use BigQuery Pipelines: a practical re-introduction - BigQuery Pipelines offers a pragmatic solution for sequencing SQL and notebook tasks within BigQuery Studio, providing a low-friction alternative to Apache Airflow for users prioritizing rapid adoption and native integration.

BigQuery Sept. 29, 2025

HyperLogLog++: Efficiently Approximate COUNT(DISTINCT) Across Modern Data Platforms - How to speed up distinct counts on massive datasets with minimal cost — examples in BigQuery.

BigQuery Billing FinOps Sept. 29, 2025

How We Cut BigQuery Costs by 50% in Production - We Saved $100K+ Annually.

BigQuery Paywall Tutorial Sept. 29, 2025

Learning PIVOT in BigQuery - A step-by-step guide to reshaping your data with PIVOT.

Big Data BigQuery Sept. 22, 2025

Replicating BigQuery Data to Another Data Warehouse - How to use Continuous Queries to Perform CDC from BigQuery.

BigQuery FinOps Sept. 22, 2025

The Price of Speed: Taming the BigQuery Autoscaler Waste - How to use the autoscaler in the most efficient way.

BigQuery Data Science Official Blog Serverless Spark Sept. 22, 2025

Announcing the new Practical Guide to Data Science on Google Cloud - Learn how to leverage Google Cloud's BigQuery, Serverless Spark, and Vertex AI for modern data science workflows. This guide covers unified tooling, end-to-end solutions, and real-world use cases with code examples.

BigQuery Official Blog Public Sector Sept. 22, 2025

Oklahoma DOT gains valuable information on the health of bridge inventory with data-driven insights on Google Cloud - Discover how ODOT is using Google Cloud to transform bridge safety. See how BigQuery, Dataplex, & AI create a data-driven model for maintenance.

BigQuery Data Analytics Official Blog Sept. 22, 2025

Power up your data analysis: The Data Science Agent now supports BigQuery ML, DataFrames, and Spark - Your AI-powered data science partner just got a major upgrade. The Data Science Agent now automates ML workflows with Spark, BigQuery ML, & BigQuery DataFrames.

BigQuery Data Analytics Official Blog Sept. 22, 2025

BigQuery under the hood: Scalability, reliability and usability enhancements for gen AI inference - With recent performance improvements to BigQuery, users can expect gains in scalability, reliability, and usability across BigQuery and BigQuery ML.

BigQuery Dataplex Sept. 15, 2025

Dataplex Catalog Export to BigQuery - Dataplex has introduced a feature to export catalog data to Google Cloud Storage, enabling snapshotting and analysis with BigQuery.

BigQuery Sept. 15, 2025

Achieve High-Performance Data Ingestion with the Storage Write API - The article discusses the BigQuery Storage Write API, introduced in 2022 as a replacement for the insertAll API, which enables efficient data streaming into BigQuery.

BigQuery Paywall Sept. 15, 2025

BigQuery Keyboard Shortcuts I Can’t Live Without - Save time, stay in flow, and make the BigQuery console work for you.

BigQuery Data Analytics Official Blog Sept. 15, 2025

BigQuery under the hood: The power of the Column Metadata index aka CMETA - BigQuery’s Column Metadata (CMETA) index delivers superior scalability and performance, with no maintenance overhead, and may reduce slot usage.

BigQuery Sept. 8, 2025

How We Migrated and Scaled Our Data Architecture for the Future - Introduction.

BigQuery Sept. 8, 2025

SAP S/4 Data Marts Cost and Performance Optimization with Google BigQuery - The article discusses cost and performance optimization of SAP S/4 data marts in Google BigQuery using primary and foreign keys. It addresses challenges in ensuring reliable keys and maintaining them, and proposes solutions like using a scheduled Airflow DAG pipeline.

Showing 271–300 of 2427 resources

 

Latest Issues




Contact

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