For Simon Data to integrate with Amazon Redshift, create a user and password via the CREATE USER command in Amazon Redshift that Simon Data can use to connect:
create user simondata password '<password here>'
Grant Simon select privileges on the appropriate table, schema, or database that we will need to extract from:
grant select on <table/schema/db> <name of table/schema/db> to simondata
- As an admin, expand Settings then click Integrations.
- Scroll down to Redshift.
- Click Add.
- Enter your host, port, database, user (the username you created specific to Simon in Redshift itself), and password.
- Click Save Changes
Successful connections display Connected in Green.
Allow the following IPs in any firewalls or systems that may block our access:
126.96.36.199 188.8.131.52 184.108.40.206 220.127.116.11 18.104.22.168 22.214.171.124
Updated 9 months ago