Environments
What are environments?
In software engineering, environments are used to develop and test code without impacting end users.
“Production” (prod) refers to the environment that end users interact with, while “development” (dev) is the environment engineers write code in. This allows engineers to work iteratively when writing and testing new code in development, and once they are confident in these changes, deploy their code to production.
Data warehouses often also use separate environments – the production environment refers to the data end users can access.
Typical data environment configurations
There are three typical ways that data teams separate their data environments:
- Separate databases (Bigquery - projects): Each environment has its own database, but with the same schemas and tables in each database. This is the most common way to separate environments.
- Separate schemas (Bigquery - datasets): Each environment has its own schema, with schemas hosted on the same database.
- Separate accounts (Bigquery - clusters/instances/organizations): Each environment has its own account. This is less common.
Setting up Evidence to use different environments
You can configure both your dev and prod environments using environment variables. Using .env
files at the project root is supported.
Dev environment
Add your dev database credentials for your dev environment via the settings page. If you are running Evidence locally, typically at http://localhost:3000/settings.
Prod environment
Add your prod database credentials as environment variables. The specific instructions depend on how you are deploying Evidence. Instructions can be be found in the deployment section of the settings page of your local project.
If you are using separate schemas, you will need to add the optional schema
parameter to your credentials in dev, and an environment variable in prod. This is only currently supported for Postgres.