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)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

AWS GenAI LIVE!

GenAI LIVE! is a dynamic live-streamed show exploring how AWS and our partners are helping organizations unlock real value with generative AI.

Tune in to the full event

DEV is partnering to bring live events to the community. Join us or dismiss this billboard if you're not interested. ❤️