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.cloud.soda.io/simple --pre -U "soda-postgres>4"

Data source YAML

Create the config file:

soda data-source create -f ds_config.yml

The data source configuration YAML should look like the following:

ds_config.yml

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_config.yml

---

You are not logged in to Soda and are viewing the default public documentation. Learn more about Documentation access & licensing.