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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay