DEV Community

Mark McCracken
Mark McCracken

Posted on

BigQuery: date sharded tables vs. native table partitions

I've used BigQuery plenty, and really enjoy working with it. One technique to reduce costs is partitioning, which can be done in a few different ways.
Here's an overview of native table partitioning vs. date sharing in BigQuery
https://mark-mccracken.medium.com/bigquery-date-sharding-vs-date-partitioning-cee3754f7900

Top comments (0)

Heroku

The AI PaaS for deploying, managing, and scaling apps.

Heroku tackles the toil — patching and upgrading, 24/7 ops and security, build systems, failovers, and more. Stay focused on building great data-driven applications.

Get Started

👋 Kindness is contagious

Sign in to DEV to enjoy its full potential.

Unlock a customized interface with dark mode, personal reading preferences, and more.

Okay