dbt Seeds

dbt Seeds #

Seeds are csv files that can be referenced from the project as if they were another table.

Useful for things like test data or references.

Mostly used for static data that is rarely changed.

Location #

By default, seeds are usually *.csv files located in the project data/ directory. The seed name is whatever the csv filename is.

The path is specified in the dbt_project.yml, with line:

data-paths: ["data"]

Create #

Load anything specified in the data-paths file as a seed with:

dbt seed

Access #

The seed can be accessed like any other data model, with:

select * from {{ ref{'<seed name>'} }}