Hi all, exists a command to test the connection to a target without running an elt? My ELT could not be completed for this

psycopg2.errors.InsufficientPrivilege: permission denied for database dbname

I run the elt for different database inherit from it and works properly. I want to debug if the problem is my configuration or in the target side. I'm using

target-redshift

thanks!

I don't think there is such a command. However, reading your error message, it seems you are trying to write to a database called

dbname

. Is that right?

No, I changet it. My database is call analytcis. This is an ss of the error message. But I appointed that is problem of privilegies of the user that I'm using, with other user I could made the elt correctly.

I think you are right, the user you are connecting to db analytics with doesn't have the necessary permissions. I haven't used redshift myself, but one thing I've been surprised is that most loaders require the CREATE SCHEMA privilege, even if the schema already exists.