what are the specific permissions the database user for Redshift target needs? I am able to connect with a super user, but my created user which has create schema, create tables is timing out with no log of what happened. It's running redshift queries but ultimately never connects. 100% it's user based because superadmin works.

If you're using S3 staging there's some more information on what's required to

COPY

into Redshift in these links: https://docs.aws.amazon.com/redshift/latest/dg/t_loading-tables-from-s3.html https://docs.aws.amazon.com/redshift/latest/dg/copy-usage_notes-access-permissions.html#copy-usage_notes-iam-permissions if you're using

INSERT

and it's timing out with those perms we might have to investigate a bit deeper

yea it was redshift user permissions not an S3 issue so that documentation isn't really pertinent..

grant

create

on

*database* xxxx *to* airbyte

that was buried somewhere here in a slack convo