Connect IntelliJ to Amazon Redshift

Question

I am using the latest version of IntelliJ, and I just created a cluster in Amazon Redshift. How to connect IntelliJ to Redshift so that I can request it from my favorite IDE?

Answer 1

• Download the jdbc driver: http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver
• IntelliJ: View |Tool Windows | Database View |Tool Windows | Database
• Click “Data Source Properties” ( )
• Click "Add" ( + ) and select "Database Driver":

5. Uncheck the "JDBC drivers" box and add the jdbc driver, select a class from the drop-down list, and select the PostgreSQL dialogs:

   6. Add a new connection and use this data source for your connection: ( + | Data Source | RedShift ).

   7.Configure URL patterns:

   • jdbc:redshift://[{host::localhost}[:{port::5439}]][/{database::postgres}?][\?<&,user={user:param},password={password:param},{:identifier}={:param}>]

   • jdbc:redshift://\[{host:ipv6:\:\:1}\][:{port::5439}][/{database::postgres}?][\?<&,user={user:param},password={password:param},{:identifier}={:param}>]

   • jdbc:redshift:{database::postgres}[\?<&,user={user:param},password={password:param},{:identifier}={:param}>]

Answer 2

You can connect IntelliJ to Redshift using the JDBC driver provided by Amazon. In the Redshift Console, go to the "Connect Client" to get the driver.

Then, in the IntelliJ data source window, add the JAR as a driver file and use the following settings:

• Class: com.amazon.redshift.jdbc41.Driver
• URL pattern: jdbc: redshift: // {host}: {port} / {database}

Common errors:

• If the driver file is not readable or is marked as quarantined in OS X, you cannot select the driver class.

See this blog post for more on this: Connect IntelliJ to Redshift

Note. IntelliJ has no built-in Redshift support. IntelliJ Issue DBE-1459