Configuring the database driver for AWS Redshift in JetBrains IDEs

Question

AWS Redshift has a PostgreSQL query interface. So I tried to set-up a connection to a cluster with the PostgreSQL driver driver in PyCharm (JetBrain IDE family): it works but there is one background job that keeps failing. The error message is:

AWSmytestdb.pg_catalog.padb_config_harvest
java.sql.SQLException: Unable to determine a value for MaxIndexKeys due to missing system catalog data.

Does AWS Redshift set a value for MaxIndexKeys at all? Does this matter? Can I turn the job off? Is there a better solution? Thanks.

Answer 1

You could try to use the jdbc driver provided by amazon. in this post I described how to install and use it in DataGrip (also Jetbrains).

Defining a Redshift connection in DataGrip