Does Motherduck Free Tier Support Table Partitioning and Clustering?

Joshua O. · 2025-09-15T09:00:35.939Z

Is there the ability for partitioning & clustering of tables on the Motherduck free tier plan

It seems likely that table partitioning is not currently supported in MotherDuck, regardless of plan. Multiple sources indicate that native table partitioning (like in Iceberg or Hive) is not available yet, and users are advised to use other strategies if they need partition-like behavior. There is no mention of clustering support either. Indexes are supported, but not partitions or clustering, on any plan including the free tier. If you need partitioning for performance or data management, you may need to implement workarounds such as using multiple tables or manual data organization. Would you like more detail on possible workarounds or future roadmap for these features?Sources: - MotherDuck Community Slack: Partitioning not yet supported

💡 Hint: Mention RunLLM in the thread for followups.

2 comments