Skip to main content

About environments

In software engineering, environments are used to enable engineers to develop and test code without impacting the users of their software. Typically, there are two types of environments in dbt:

  • Deployment or Production (or prod) — Refers to the environment that end users interact with.

  • Development (or dev) — Refers to the environment that engineers work in. This means that engineers can work iteratively when writing and testing new code in development. Once they are confident in these changes, they can deploy their code to production.

In traditional software engineering, different environments often use completely separate architecture. For example, the dev and prod versions of a website may use different servers and databases. Data warehousesA data warehouse is a data management system used for data storage and computing that allows for analytics activities such as transforming and sharing data. can also be designed to have separate environments — the production environment refers to the relations (for example, schemas, tables, and viewsA view (as opposed to a table) is a defined passthrough SQL query that can be run against a database (or data warehouse).) that your end users query (often through a BI tool).

Configure environments to tell dbt Cloud or dbt Core how to build and execute your project in development and production:


0