HomeDemoContact

Redshift

Suggest Edits

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

FieldRequiredDescriptionExample
Name✅Identifier for the credentials. Used when accessing sources.service_acount_product_staging
Host✅Endpoint of the Redshift cluster database.test-redshift-cluster-1.ynypdanx10uk.eu-north-1.redshift.amazonaws.com
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

FieldRequiredDescription
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.

Updated 4 days ago