Prerequisite credentials

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

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


Permissions for user accounts

Certain permissions are required for the user account.
For more information, refer to the Redshift documentation.

User account for Source config

We recommended that you create a user account with read access to the table you want to ingest data from.

Example of user account in Redshift

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

# Create a user with a password. Use a username and password of your choice.
CREATE USER validio_user WITH password 'securepassword'

# Create a group for the user. Use a group name of your choice.
CREATE GROUP validio_group;

# Add the newly created 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 for the group to user schema containing the table.
GRANT USAGE ON SCHEMA my_schema TO GROUP validio_group;

# Grant read only access for the group to the table in the schema.
GRANT SELECT ON my_schema.my_table TO validio_group;

Credential parameters

Nameβœ…Identifier for the credentials. Used when accessing sources.service_acount_product_staging
Hostβœ…Endpoint of the Redshift cluster
Portβœ…Port number of the database.
Userβœ…Username of Redshift account with read access to the desired table.
Passwordβœ…Password of the specified Redshift user.
Default databaseβœ…Name of the default Redshift database.

Configuration parameters

Nameβœ…Identifier for the connector. Used when setting up validators.
Databaseβœ…Name of the Redshift 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 presetDetermines 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.