In this chapter, we will explore the concept of sources and seeds in dbt. These two items are mostly independent of each other, and we combined them into the same chapter as they are smaller, but very important, subjects. Sources refer to the original data sources, such as data from databases, that are used as the input for dbt. Source tables are referred to in dbt models via a Jinja function, which we will discuss more later in the chapter. Seeds, on the other hand, refer to the data that is used to populate the initial sets on small, unchanging data, typically used for reference data or lookup tables. Seeds are still referenced within models utilizing a Jinja function but use a different command than sources.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Sources and Seeds

  • Dustin Dorsey,
  • Cameron Cyr

摘要

In this chapter, we will explore the concept of sources and seeds in dbt. These two items are mostly independent of each other, and we combined them into the same chapter as they are smaller, but very important, subjects. Sources refer to the original data sources, such as data from databases, that are used as the input for dbt. Source tables are referred to in dbt models via a Jinja function, which we will discuss more later in the chapter. Seeds, on the other hand, refer to the data that is used to populate the initial sets on small, unchanging data, typically used for reference data or lookup tables. Seeds are still referenced within models utilizing a Jinja function but use a different command than sources.