Today we're announcing new Storage API feature: Bucket Credentials (api here).
If you're using Keboola Connection w/ Redshift backend, you can have read-only credentials (direct sql access) to any Redshift bucket.
In Storage API Console, go to Bucket Detail > Credentials and press "Create new credentials" button:
Describe new credentials (you can have multiple credentials assigned to each bucket!):
When you create credentials, carefully copy&paste credentials to you SQL client or preferred remote service (jackdb.com, chartio.com, etc.). After closing displayed credentials, you can't display it's settings:
In case you need to re-use already created credentials, you have to delete it and create new combination of username and password. All existing credentials are listed under it's bucket:
- credentials can be used for accessing just one bucket
- write access isn't supported
WARNING: Always employ SSL when accessing your data. Generated credentials are opening your dedicated AWS Redshift Cluster. Please read "Configure Security Options for Connections". Redshift Cluster's CA certificate can be downloaded here.