Prerequisite credentials

You need the following to configure PostgreSQL credentials in the Validio platform:

A user account with permissions to access the specified dataset and table.

User account for Source config

We recommended that you create a user account with read access for the Validio platform to ingest data from PostgreSQL.

The following shows an example of setting up a user account in PostgreSQL:

# Assign a user name and password
CREATE USER validio_user WITH password 'password'

# Create a group for the user
CREATE GROUP validio_group;

# Add the user to the created group.
ALTER GROUP validio_group ADD USER validio_user;

The following shows an example of setting up read-only access to a configured table:

# Grant access to the configured <schema>.
GRANT USAGE ON SCHEMA "<schema>" TO GROUP validio_group;

# Grant read only access to the configured <table> and <schema>.
GRANT SELECT ON <schema>.<table> TO validio_group;

Credential parameters

Field	Required	Description	Example
Name	✅	Identifier for the credentials. Used when accessing sources.	service_acount_product_staging
Host	✅	DNS hostname or IP address at which to reach the database server.
Port	✅	Port number of the database server.
User	✅	Username of Postgres account with read access to the desired table.
Password	✅	Password of the specified Postgres user.
Default database	✅	Name of the default postgres database where the table to read is included.

Configuration parameters

Field	Required	Description
Name	✅	Identifier for the connector. Used when setting up validators.
Database	✅	Name of the Postgres database where the table to read from is included.
Schema	✅	Name of the schema that contains the table to read from.
Table	✅	Name of the table from which to ingest data from.
Cron preset		Determines how often to query the bucket for new data based on a preset option. Select custom to use your own cron expression.
Cron expression	✅	Determines how often to query the table for new data based on cron expression. Expression of cron presets are displayed here. Used to enter your own cron expression.