Defining a Redshift connection in DataGrip
I'm trying to define a Redshift connection in DataGrip but couldn't find any Redshift driver in the UI. I tried using both Postgres and generic Database Driver with no luck.
Has someone been able to configure this?
Answer
If you want to connect DataGrip to Redshift I suggest you use the jdbc drivers from AWS. Just download them to a directory where you can keep them.
Then you open DataGrip and go to the data sources menu (⌘;).
Right-Click on one of the pre-installed drivers or somewhere in the driver section. And select 'Add → Driver'
Give it a good name like 'Redshift' and in the bottom part, click on the + Symbol under Driver files, select the driver you just downloaded and click OK.
Under class, select com.amazon.redshift.jdbc41.Driver, under Dialect, select PostgreSQL.
Now you can go to the data sources menu (⌘;) and click on the "+" symbol in the top left corner and select the Driver you just created (in my case it's called "Redshift") as the data source type.
Now copy your redshift jdbc url (you can find it in your cluster configuration under "Cluster Database Properties") into the URL field and fill the user and password fields with your credentials.
Now can you click on "Test Connection" and it should work.
I hope this helps. If you have further questions or problems to follow the instructions, feel free to comment.