Hi there. Has someone successfully connected goodata with an aws redshift instance? I've got all the data ready to be read. I found the JDBC-URL to connect to, but I'm stuck at giving the correct permissions.

Hi Mike, If I’m not mistaken, you are using GoodData Cloud is that correct? In any case, you have two options: 1. Either you create a dedicated user and user role for integration with the GoodData platform 2. Or if you use AWS Identity and Access Management (IAM) for Redshift authentication: Create an IAM role or user with permissions to call

GetClusterCredentials

More details on each possibility can be found in the bellow documentation: https://www.gooddata.com/docs/cloud/connect-data/create-data-sources/redshift/#CreateanAmazonRedshiftDataSource-ConfigureUserAccessRights In case of further struggles/questions, let us know.

Thanks @Julius Kos for your help! I'm on a cloud trial instance, thats right. Still no success so far. I've created a user in Amazon IAM with fully redshift:* permissions. Questions: • do I need to create an access key (key and secret) and use that as username and password? or • do I need to create a console login with a password? Is the username then the fully ARN of the user, or only the username? • are you aware that in Amazon Redshift, there is a whole configuration about "Data-Access" from outside (VPC config, Subnets, ...) - nothing is mentioned in the docs if I need to configure something there • the docs talk about "Basic authentication is supported. Specify user and password." - Where would I setup Basic Auth in Amazon IAM? I'm not sure if the documentation is lacking a lot of information or maybe Amazon has built a lot of security features into Redshift which is not covered right now, but I'm pretty sure, its not possible to setup the connection for me right now.