Integrating Redshift with SYNQ
Step 4 goes through how to set permissions to allow access to querying raw data
Table Description svv_redshift_databases List of all the databases that a user has access to svv_all_schemas Summary of schemas svv_table_info Summary information for tables in the database svv_external_tables Details for external tables such as table and schema names
<password>
is a secret you can set to be used by SYNQ
WITH NO SCHEMA BINDING
we need USAGE
grant for both schemas, the one in which late binding view is defined and the one from which it is reading. This has to be repeated for every schema:
USAGE
to all schemas one can use:
Workgroup configuration
and click your default Workgroup
Edit
and check the Turn on Publicly accessible checkmark. Then click Save changes
Edit inbound rules
. Then click Add rule
and populate it with the following information
All Traffic
Custom
with the following value in the text field: 34.105.135.39
Save rules
Workgroup configuration
and select your default workgroup. Take a note of your JDBC URL
Redshift
example_production_database
)
cluser-name.us-east-1.redshift.amazonaws.com
)
To find the host, go to Workgroup configuration, and look at the Endpoint.
Copy everything until the amazonaws.com
and leave out the rest. In most cases, that will be :5439/dev
.
Paste it into the Host field in SYNQ.
5439
Connect failed
error after double-checking your details, try again later.