BigQuery Introduces Metadata Caching for SQL Translation

March 31, 2025 at 3:44:54 AM

TL;DR Google has introduced a preview feature for BigQuery that enables metadata caching for SQL translation, reducing latency for subsequent requests. Users can enhance translation quality by running interactive queries with configurations stored in YAML files in Cloud Storage, which may include SQL metadata, object mapping, DDL information, and schemas. Users can specify these configurations in the query editor. Cached metadata remains active for up to 7 days.

BigQuery Introduces Metadata Caching for SQL Translation

Google has released a new preview feature that enables metadata caching for SQL translation in BigQuery, significantly reducing latency for subsequent translation requests.

Users can now enhance translation quality by running interactive queries with additional translation configurations. This is accomplished by specifying configuration YAML files stored in a Cloud Storage folder. These configurations may include:

  • SQL object metadata
  • Object mapping information from source databases
  • DDL information
  • Schemas from source databases

How to Specify Translation Configurations

To specify translation configurations from source files:

  1. Navigate to the query editor and click More > Translation settings
  2. Enter the path to your translation configuration files in the Translation Configuration Source Location field
  3. Click Save

The BigQuery interactive SQL translator supports metadata ZIP files containing translation metadata and object name mapping. Users seeking information on uploading files to Cloud Storage can refer to the "Upload objects from a filesystem" documentation.

Enabling Metadata Caching

The new metadata caching feature provides significant performance improvements:

  1. In the query editor, select More > Translation settings
  2. Check the Enable metadata caching checkbox
  3. Click Save

For jobs with large metadata files, this process substantially reduces translation latency for subsequent requests. Cached metadata remains active for up to 7 days.

This feature is currently in preview. Users who wish to request support or provide feedback for this feature can contact bq-edw-migration-support@google.com.

Have more questions on this topic? Ask our AI assistant for in-depth insights.

Read more from sources πŸ‘‡

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

BigQuery Data Transfer Service adds Google Analytics 4 reporting support Trending ️‍πŸ”₯

BigQuery Data Transfer Service adds Google Analytics 4 reporting support

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Updates BigQuery with New Pipelines, Version Control, and Claude AI Integration

Google Updates BigQuery with New Pipelines, Version Control, and Claude AI Integration

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Makes Analytics Hub Egress Controls and Data Clean Room Subscriptions Widely Available

BigQuery Makes Analytics Hub Egress Controls and Data Clean Room Subscriptions Widely Available

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
AI marketing workflows made simple

AI marketing workflows made simple

Featured
Markifact
Markifact

Verified Sponsor

Verified Sponsor

Markifact is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor
BigQuery Data Transfer Service adds custom reports support for Google Ads

BigQuery Data Transfer Service adds custom reports support for Google Ads

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Enhances Gemini in BigQuery with Python Code Completion

Google Enhances Gemini in BigQuery with Python Code Completion

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Enhances Resource Utilization Charts with New Metrics and Configuration Options

BigQuery Enhances Resource Utilization Charts with New Metrics and Configuration Options

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Launches Gemini AI-Powered Join Operations in BigQuery Data Preparation

Google Launches Gemini AI-Powered Join Operations in BigQuery Data Preparation

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source

Related Tools

Markifact logo

Markifact

Verified Tool

Verified Tool

Markifact is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Marketing Workflows Powered by AI

Featured
Marketing Auditor logo

Marketing Auditor

Verified Tool

Verified Tool

Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated audits for Google Ads and Analytics.

Get Featured Here

Showcase your tool in this list.

Contact Us
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
GA4 SQL logo

GA4 SQL

Verified Tool

Verified Tool

GA4 SQL is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Generate GA4 BigQuery queries easily

Data Analysis
TapClicks logo

TapClicks

Automated marketing solutions powered by your data

Data Engineering
Stitch logo

Stitch

Automated cloud data pipelines, no coding needed

Data Engineering
Akkio logo

Akkio

AI-powered analytics for agencies

Data Analysis
NinjaCat logo

NinjaCat

AI-powered marketing data and analytics platform

Reporting
Funnel logo

Funnel

Aggregate and analyze marketing data seamlessly

Reporting
Fivetran logo

Fivetran

Effortlessly centralize and move data from any source

Data Engineering

Get Featured Here

Showcase your tool in this list.

Contact Us