Skip to main content
To add PostgreSQL as a data source, go to Settings → Workspace → Integrations → Datasources and click New Datasource. Select PostgreSQL and fill in the connection parameters below, then click Test & Save Datasource.

​
Connection parameters

FieldDescription
Connection NameA label for this connection within Datachecks
HostThe server name hosting your database
PortDefault is 5432. Specify an alternative if your server uses a different port
UsernameThe dedicated user for Datachecks
PasswordThe password for the Datachecks user
DatabaseThe name of the PostgreSQL database you want to connect to
SchemaOptional — specify to limit access to a single schema

​
Setup

Run the following SQL on your PostgreSQL instance to create a dedicated user for Datachecks. 
CREATE SCHEMA datachecks_tmp;
CREATE ROLE datachecks WITH LOGIN ENCRYPTED PASSWORD 'YourSecurePassword';
GRANT ALL ON SCHEMA datachecks_tmp TO datachecks;
GRANT USAGE ON SCHEMA <myschema> TO datachecks;
GRANT SELECT ON ALL TABLES IN SCHEMA <myschema> TO datachecks;
The datachecks_tmp schema is used for temporary processing and keeps Datachecks operations isolated from your production data.