Hi. I’m trying to run an ETL pipeline for an RDS for Postrgres target (target-postgres), but I’m getting an error:
2022-05-11T000354.416272Z [info ] psycopg2.errors.InsufficientPrivilege: permission denied for database beh_test cmd_type=loader job_id=beh_test1 name=target-postgres run_id=42e076b8-1a4d-46f7-8272-9a63d903fc8d stdio=stderr
The Postgres user/role I’m using is a member of the rds_superuser role. Is something else required? Is there something else I’m missing? (Fyi, it works when using a local Postgres target (i.e. target-postgres).