在 DataGrip 中定义 Redshift 连接

我尝试在 DataGrip 中定义 Redshift 连接，但在 UI 中找不到任何 Redshift 驱动程序。我尝试使用 Postgres 和通用数据库驱动程序，但没有成功。

有人能够配置这个吗？

如果您想将 DataGrip 连接到 Redshift 我建议您使用来自 AWS 的 jdbc 驱动程序 http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html。只需将它们下载到可以保存它们的目录即可。

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.

现在您可以单击“测试连接”，它应该可以工作。

我希望这有帮助。如果您对遵循说明还有其他疑问或问题，请随时发表评论。