# \#seeds

**URL:** https://discourse.getdbt.com/tag/seeds/2.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [seed tests and documentation is missing](https://discourse.getdbt.com/t/seed-tests-and-documentation-is-missing/17786)

<div class="topic-metadata">

**Author:** [@Izaak](https://discourse.getdbt.com/u/Izaak)\
**Replies:** 1\
**Last updated:** [January 20, 2025, 1:03pm UTC](https://discourse.getdbt.com/t/seed-tests-and-documentation-is-missing/17786 "2025-01-20T13:03:31Z")

</div>

The problem I’m having I’m trying to define documentation and tests on my seeds. But I am unable to view the docs or run the tests. What I’ve already tried As per dbt-docs I’ve created a \[any\_name\].yml file in my seeds …

---

## [Create empty table through dbt seed](https://discourse.getdbt.com/t/create-empty-table-through-dbt-seed/11667)

<div class="topic-metadata">

**Author:** [@ajsheth](https://discourse.getdbt.com/u/ajsheth)\
**Replies:** 7\
**Last updated:** [December 9, 2024, 11:29pm UTC](https://discourse.getdbt.com/t/create-empty-table-through-dbt-seed/11667 "2024-12-09T23:29:23Z")

</div>

I just found a trick in dbt to create empty tables and thought I would share with a wider audience and perhaps gather some feedback. I was working on a POC where I needed dbt to create an empty staging table just once. I…

---

## [Seeds overwrites CSV file if outside directory containing yml files](https://discourse.getdbt.com/t/seeds-overwrites-csv-file-if-outside-directory-containing-yml-files/12972)

<div class="topic-metadata">

**Author:** [@CaptinCCat](https://discourse.getdbt.com/u/CaptinCCat)\
**Replies:** 1\
**Last updated:** [October 23, 2024, 2:19am UTC](https://discourse.getdbt.com/t/seeds-overwrites-csv-file-if-outside-directory-containing-yml-files/12972 "2024-10-23T02:19:50Z")

</div>

The problem I’m having We would like our Seed files for a project to be outside the directory for the dbt code that we are running, more specifically located in a data folder that is located in a directory above where th…

---

## [dbt seed error with schema config](https://discourse.getdbt.com/t/dbt-seed-error-with-schema-config/15491)

<div class="topic-metadata">

**Author:** [@fred](https://discourse.getdbt.com/u/fred)\
**Replies:** 1\
**Last updated:** [September 18, 2024, 1:48pm UTC](https://discourse.getdbt.com/t/dbt-seed-error-with-schema-config/15491 "2024-09-18T13:48:44Z")

</div>

I am trying to seed a small csv file in Redshift with the schema element in my config. I need to write this seed to a schema that is not the target schema. I would prefer to specify this configuration in the properties.y…

---

## [Casting column datatypes based on a seed](https://discourse.getdbt.com/t/casting-column-datatypes-based-on-a-seed/4877)

<div class="topic-metadata">

**Author:** [@leogodin](https://discourse.getdbt.com/u/leogodin)\
**Replies:** 1\
**Last updated:** [April 11, 2024, 7:01pm UTC](https://discourse.getdbt.com/t/casting-column-datatypes-based-on-a-seed/4877 "2024-04-11T19:01:58Z")

</div>

Old thread, I know, but I ran into this recently. We have a simple data dictionary that lists source column name, target column name and data type. At the same time, we are pivoting key/value pairs to a wide format. To …

---

## [DBT is taking too much time to upload large size seed data(3GB) to datawarehouse](https://discourse.getdbt.com/t/dbt-is-taking-too-much-time-to-upload-large-size-seed-data-3gb-to-datawarehouse/9279)

<div class="topic-metadata">

**Author:** [@unknownfakir1](https://discourse.getdbt.com/u/unknownfakir1)\
**Replies:** 1\
**Last updated:** [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 "2023-07-26T13:29:41Z")

</div>

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.

---

## [Error while processing seed -'The incoming request has too many parameters'](https://discourse.getdbt.com/t/error-while-processing-seed-the-incoming-request-has-too-many-parameters/8953)

<div class="topic-metadata">

**Author:** [@datastiks](https://discourse.getdbt.com/u/datastiks)\
**Replies:** 2\
**Last updated:** [July 3, 2023, 12:05pm UTC](https://discourse.getdbt.com/t/error-while-processing-seed-the-incoming-request-has-too-many-parameters/8953 "2023-07-03T12:05:22Z")

</div>

I am trying to create a seed file with 128 rows and 20 columns in dbt project. I am getting below DB error while seed creation. Database Error : 06:06:59 (‘42000’, ‘\[42000\] \[Microsoft\]\[ODBC Driver 17 for SQL Server…

---

## [Prevent people from using seeds for data loading with a custom materialization](https://discourse.getdbt.com/t/prevent-people-from-using-seeds-for-data-loading-with-a-custom-materialization/8715)

<div class="topic-metadata">

**Author:** [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Replies:** 2\
**Last updated:** [June 22, 2023, 1:51pm UTC](https://discourse.getdbt.com/t/prevent-people-from-using-seeds-for-data-loading-with-a-custom-materialization/8715 "2023-06-22T13:51:45Z")

</div>

@jaypeedevlin asked and answered a great question on the dbt Slack: Has anyone hacked together anything to prevent seeds beyond a certain size? We’d like to put some sort of barrier in place to stop folks using seeds …

---

## [Seeds headers limitations](https://discourse.getdbt.com/t/seeds-headers-limitations/8456)

<div class="topic-metadata">

**Author:** [@moseleyi](https://discourse.getdbt.com/u/moseleyi)\
**Replies:** 4\
**Last updated:** [June 13, 2023, 7:15am UTC](https://discourse.getdbt.com/t/seeds-headers-limitations/8456 "2023-06-13T07:15:09Z")

</div>

Where can I find information about what headers of a csv file can and can’t look like? I’ve been trying to load a CSV with all columns and values quoted and I’m still getting a lot of errors: ←\[0m11:47:45 001003 (420…

---

## [Load a csv file into Snowflake with dbt](https://discourse.getdbt.com/t/load-a-csv-file-into-snowflake-with-dbt/7750)

<div class="topic-metadata">

**Author:** [@vinayak144800](https://discourse.getdbt.com/u/vinayak144800)\
**Replies:** 1\
**Last updated:** [April 18, 2023, 10:27pm UTC](https://discourse.getdbt.com/t/load-a-csv-file-into-snowflake-with-dbt/7750 "2023-04-18T22:27:03Z")

</div>

Hi I want to load a csv file into dbt so that it creates table in snowflake without using seeds like in simple elt process simply we are extracting the data from csv file and load that data in snowflake using dbt and tr…

---

## [loading seed with SUPER type to Redshift](https://discourse.getdbt.com/t/loading-seed-with-super-type-to-redshift/5287)

<div class="topic-metadata">

**Author:** [@yken](https://discourse.getdbt.com/u/yken)\
**Replies:** 1\
**Last updated:** [January 4, 2023, 5:19pm UTC](https://discourse.getdbt.com/t/loading-seed-with-super-type-to-redshift/5287 "2023-01-04T17:19:51Z")

</div>

Hi, I’m trying to load a seed file to Redshift. My seed has a column of the SUPER type (has JSON for value), but the value of that column is not how I expect it to be. The expected value should be: {"parameter":"82c4a…

---

## [Multiple Case Statements Wildcard matches](https://discourse.getdbt.com/t/multiple-case-statements-wildcard-matches/5436)

<div class="topic-metadata">

**Author:** [@derrickt](https://discourse.getdbt.com/u/derrickt)\
**Replies:** 2\
**Last updated:** [December 1, 2022, 2:13am UTC](https://discourse.getdbt.com/t/multiple-case-statements-wildcard-matches/5436 "2022-12-01T02:13:44Z")

</div>

Hello! I’m trying to create a set something similar to the following {%- set payment\_methods = \['bank\_transfer', 'credit\_card', 'coupon', 'gift\_card'\] -%} with payments as ( select \* from {{ ref('stg\_payments') }} …

---

## [Can you test only the seeds folder?](https://discourse.getdbt.com/t/can-you-test-only-the-seeds-folder/5259)

<div class="topic-metadata">

**Author:** [@catarina.ribeiro](https://discourse.getdbt.com/u/catarina.ribeiro)\
**Replies:** 1\
**Last updated:** [November 3, 2022, 6:30pm UTC](https://discourse.getdbt.com/t/can-you-test-only-the-seeds-folder/5259 "2022-11-03T18:30:08Z")

</div>

Hi there! Can I test dbt seeds folder only? I manage to test my seed when running dbt test, but it tests everything in my project… I would like to test only the seeds… I’ve also tried dbt test --select seeds and a bun…

---

## [What can I use to load monthly updating Excel files to database?](https://discourse.getdbt.com/t/what-can-i-use-to-load-monthly-updating-excel-files-to-database/4954)

<div class="topic-metadata">

**Author:** [@nancy.chelaru](https://discourse.getdbt.com/u/nancy.chelaru)\
**Replies:** 3\
**Last updated:** [September 29, 2022, 6:49pm UTC](https://discourse.getdbt.com/t/what-can-i-use-to-load-monthly-updating-excel-files-to-database/4954 "2022-09-29T18:49:51Z")

</div>

Hello everyone! Each month, we have a number of Excel files that have ~20-60K rows that need to be uploaded to the database as tables that are then used in downstream data models. They require some light data cleaning b…

---

## [How can I upload CSV File in seeds?](https://discourse.getdbt.com/t/how-can-i-upload-csv-file-in-seeds/4909)

<div class="topic-metadata">

**Author:** [@Nikitha9798](https://discourse.getdbt.com/u/Nikitha9798)\
**Replies:** 1\
**Last updated:** [September 12, 2022, 8:55am UTC](https://discourse.getdbt.com/t/how-can-i-upload-csv-file-in-seeds/4909 "2022-09-12T08:55:35Z")

</div>

Hi, Can you help me how to upload a CSV file in seeds from local system.

---

## [Seed data column type changes aren't being applied](https://discourse.getdbt.com/t/seed-data-column-type-changes-arent-being-applied/2727)

<div class="topic-metadata">

**Author:** [@yduan](https://discourse.getdbt.com/u/yduan)\
**Replies:** 4\
**Last updated:** [September 4, 2022, 11:35pm UTC](https://discourse.getdbt.com/t/seed-data-column-type-changes-arent-being-applied/2727 "2022-09-04T23:35:19Z")

</div>

I followed the instructions described in Seed configurations | dbt Docs to customize a couple of columns’ data type, but seems dbt did pick up the config, but did nothing, column types were still inferred wrong. Is this…

---

## [How to specify distribution/sort style and column encoding for dbt seeds in Redshift?](https://discourse.getdbt.com/t/how-to-specify-distribution-sort-style-and-column-encoding-for-dbt-seeds-in-redshift/4858)

<div class="topic-metadata">

**Author:** [@evgeniy](https://discourse.getdbt.com/u/evgeniy)\
**Replies:** 1\
**Last updated:** [September 4, 2022, 11:29pm UTC](https://discourse.getdbt.com/t/how-to-specify-distribution-sort-style-and-column-encoding-for-dbt-seeds-in-redshift/4858 "2022-09-04T23:29:31Z")

</div>

How to specify distribution and sort style for dbt seeds? There are no .sql files associated with seeds. How do we define the config? And how do we define column encoding algorithms?

---

## [Why can't I use dbt seed for large .csv files?](https://discourse.getdbt.com/t/why-cant-i-use-dbt-seed-for-large-csv-files/328)

<div class="topic-metadata">

**Author:** [@Bijan](https://discourse.getdbt.com/u/Bijan)\
**Replies:** 2\
**Last updated:** [May 1, 2019, 2:51am UTC](https://discourse.getdbt.com/t/why-cant-i-use-dbt-seed-for-large-csv-files/328 "2019-05-01T02:51:46Z")

</div>

Hi, I have a few rather large but static files that I would like to upload using dbt seed. More precisely, they are files of legacy data from systems not active anymore, and while it’s well possible to host them elsewh…