Skip to main content

Loading Data into MotherDuck

You can leverage MotherDuck's managed storage to persist your data. MotherDuck storage provides a high level of manageability and abstraction, optimizing your data for secure, durable, performant, and efficient use. There are several ways to load data into MotherDuck storage.

Before You Start: Understanding Trade-offs​

Before choosing a loading method, it's important to understand the performance implications and trade-offs involved. Our Considerations for Loading Data guide explains:

  • Batch vs. streaming approaches and when to use each
  • File format choices and their impact on performance
  • Optimal batch sizes for different scenarios
  • Cost implications of different loading strategies
  • Common performance pitfalls and how to avoid them

This understanding will help you make informed decisions that optimize for your specific use case.