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)

Jetbrains image

Build Secure, Ship Fast

Discover best practices to secure CI/CD without slowing down your pipeline.

Read more

👋 Kindness is contagious

Dive into this informative piece, backed by our vibrant DEV Community

Whether you’re a novice or a pro, your perspective enriches our collective insight.

A simple “thank you” can lift someone’s spirits—share your gratitude in the comments!

On DEV, the power of shared knowledge paves a smoother path and tightens our community ties. Found value here? A quick thanks to the author makes a big impact.

Okay