PostgreSQL

Access configuration details to connect Soda to a PostgreSQL data source.

Connection configuration reference

Install the package soda-postgres:

pip install -i https://pypi.dev.sodadata.io/simple -U soda-postgres

Data source YAML

type: postgres
name: my_postgres
connection:
  user: ${env.POSTGRES_USER}
  host: ${env.POSTGRES_HOST}
  port: 5432
  password: ${env.POSTGRES_PW}
  database: ${env.POSTGRES_DB}

Connection test

Test the data source connection:

soda data-source test -ds ds.yml