PostgreSQL
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. |
Updated 4 days ago