Setting up the connection

  • Before connecting Postgres to Causal you might have to white list the following IP addresses in your Postgres database:
  • Go to the Causal data page and create a new Postgres data source
  • Click "+ New Connection" and fill in the database credentials

  • Once authenticated you will be brought to a configuration form like this:

To configure your Postgres data source you will need to specify the query, the date column, and any variable columns. The date column should be one of Postgres's date formats and the variable columns should be numeric.

Any columns that aren't a date or variable column will be considered a category, and should have a string type. An exception is the 'cohort' category, which should be a date, with the column header explicitly labelled Cohort.

For more details about how to write queries for Causal data sources check out Table Format.