# DBT is taking too much time to upload large size seed data(3GB) to datawarehouse

**URL:** <https://discourse.getdbt.com/t/dbt-is-taking-too-much-time-to-upload-large-size-seed-data-3gb-to-datawarehouse/9279>\
**Category:** Help\
**Tags:** seeds, dbt-core\
**Created:** [July 25, 2023, 5:01am UTC](https://discourse.getdbt.com/t/dbt-is-taking-too-much-time-to-upload-large-size-seed-data-3gb-to-datawarehouse/9279 "2023-07-25T05:01:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![unknownfakir1](https://avatars.discourse-cdn.com/v4/letter/u/a4c791/32.png) [@unknownfakir1](https://discourse.getdbt.com/u/unknownfakir1)\
**Post date:** [July 25, 2023, 5:01am UTC](https://discourse.getdbt.com/t/dbt-is-taking-too-much-time-to-upload-large-size-seed-data-3gb-to-datawarehouse/9279/1 "2023-07-25T05:01:00Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/2X/0/038575af76e5fc187e4288679026086c20492b04.png)  
I am trying to load seed file to data warehouse. But it took 67 minutes to load,what can we do to decrease the this time.  
My file size is 3gb.

---

<div class="post-metadata">

**Author:** ![brunoszdl](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/brunoszdl/32/4113_2.png) [@brunoszdl](https://discourse.getdbt.com/u/brunoszdl)\
**Post date:** [July 26, 2023, 1:29pm UTC](https://discourse.getdbt.com/t/dbt-is-taking-too-much-time-to-upload-large-size-seed-data-3gb-to-datawarehouse/9279/2 "2023-07-26T13:29:41Z")

</div>

I’ve seen a rule of thumb here somewhere that said if a seed is more than one or a couple MB it should not be a seed.

You can also refer to this FAQ

> **[Add Seeds to your DAG | dbt Developer Hub](https://docs.getdbt.com/docs/build/seeds#faqs)**
>
> Read this tutorial to learn how to use seeds when building in dbt.

Seeds should **not** be used to load raw data (for example, large CSV exports from a production database).

Since seeds are version controlled, they are best suited to files that contain business-specific logic, for example a list of country codes or user IDs of employees.

Loading CSVs using dbt’s seed functionality is not performant for large files. Consider using a different tool to load these CSVs into your [data warehouse](https://docs.getdbt.com/terms/data-warehouse).