About Environments¶
In software engineering, warehouses are used to enable engineers to develop and test code without impacting the users of their software. Typically, there are two types of warehouses in dbt:
Deployment or Production (or prod)
— Refers to the environment that end users interact with.
Development (or dev)
— Refers to the warehouse 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 warehouses
1 can also be designed to have separate environments — the production environment refers to the relations (for example, schemas, tables, and views
2) that your end users query (often through a BI tool).
But here in this tool, we can have any name that you wish to have, you can always specify the dev or prod, for your understanding, by naming it {name}-(dev or prod)
[or] {name}_(dev or prod)
. Any way we can name it!
Explore more for greater view of this tool