DataGrip (and the other jetbrains apps) were refusing to connect to heroku postgresql databases even though the connection was correct.

Turns out that you must have SSL enabled but can't validate the certificate.

Add the following properties to the datasource advanced settings:

Or to the url

?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory