BigQuery Now Allows Default Storage Billing Configuration for New Datasets

July 17, 2024 at 7:22:41 PM

BigQuery Now Allows Default Storage Billing Configuration for New Datasets

A default storage billing dataset for new datasets in BigQuery can now be set at the organization or project level.

Storage Billing Options

BigQuery offers two storage billing options:

  • Physical Storage Billing: Costs $0.04 per GB per month for active storage and $0.02 for long-term storage.
  • Logical Storage Billing: Costs $0.02 per GB per month for active storage and $0.01 for long-term storage.

1721242119466.jpeg

Cost Comparison

  • Physical Storage: Calculated based on physical bytes and includes time travel storage.
  • Logical Storage: Calculated based on logical bytes.

Savings Potential

For highly compressible tables, such as Google Analytics 4 exports, physical storage can result in significant savings:

  • Example: A 15x compression rate can lead to up to 86.7% cost savings compared to logical storage.

Implementation

With the update, you can preset storage billing to physical at the organization or project level, simplifying the process for new datasets.

For optimal cost efficiency, regularly monitor datasets and choose the appropriate storage billing option for each dataset individually.

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

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

Audit your GA4 account in Minutes

Audit your GA4 account in Minutes

Sponsored
GA4 Auditor
GA4 Auditor

Verified Sponsor

Verified Sponsor

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

Verified Sponsor
BigQuery Launches Gemini-Enhanced SQL Translation Features

BigQuery Launches Gemini-Enhanced SQL Translation Features

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 Data Transfer Service Launches Data Source Change Log for Schema Updates

BigQuery Data Transfer Service Launches Data Source Change Log for Schema Updates

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 Introduces AI-Augmented Data Preparation with Gemini

BigQuery Introduces AI-Augmented Data Preparation with Gemini

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 Introduces Fine-Grained DML for Optimized Data Mutations

BigQuery Introduces Fine-Grained DML for Optimized Data Mutations

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 Analytics 4 Enhances BigQuery Export with New Session Traffic Source Data

Google Analytics 4 Enhances BigQuery Export with New Session Traffic Source Data

Brais Calvo
Brais Calvo

Top Creator

Top Analytics Creator

Brais Calvo is a Top Analytics Creator. Part of Swipe Insight Select, a curated list of top creators.

Top Analytics Creator
Google Unveils BigQuery Pipe Syntax for Easier SQL Queries Trending ️‍πŸ”₯

Google Unveils BigQuery Pipe Syntax for Easier SQL Queries

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 Introduces Airflow DAG Management Features in Preview

BigQuery Introduces Airflow DAG Management Features in Preview

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

GA4 Auditor logo

GA4 Auditor

Verified Tool

Verified Tool

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

Verified Tool

Automated GA4 audits with actionable insights

Get Featured Here

Showcase your tool in this list.

Contact Us
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
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
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
Power My Analytics logo

Power My Analytics

Automate and integrate your marketing data

Reporting

Get Featured Here

Showcase your tool in this list.

Contact Us