1. Data Warehouses
  2. Postgres

Data monitoring

Full support from versions CLI 0.6.6 and dbt package 0.6.11.


Postgres connection profile

After installing Elementary’s dbt package upon running dbt deps, you can generate Elementary’s profile for usage with edr by running the following command within your project:

dbt run-operation elementary.generate_elementary_cli_profile

The command will print to the terminal a partially filled template of the profile that’s needed for edr to work. Fill in the missing authentication fields in the output and copy it to ~/.dbt/profiles.yml.

Postgres
## POSTGRES ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: postgres
      host: [hostname]
      user: [username]
      password: [password]
      port: [port]
      dbname: [database name]
      schema: [schema name]  # elementary schema, usually [schema name]_elementary
      threads: [1 or more] 
      keepalives_idle: 0 # default 0 seconds
      connect_timeout: 10 # default 10 seconds
      # search_path: public # optional, not recommended
      # role: [optional, set the role dbt assumes when executing queries]
      # sslmode: [optional, set the sslmode used to connect to the database]


We support the same format and connection methods (user password, key pair authentication, SSO) as dbt. Please refer to dbt’s documentation of Postgres profile for further details.

Have a question?

We are available on Slack, reach out for any kind of help!