安装Snowflake JDBC驱动程序 [英] Installing Snowflake JDBC driver

问题描述

我正在尝试根据说明安装Snowflake JDBC驱动程序。

我已经从此处，然后从此处。当我双击该文件时，没有任何反应。因此，我打开了CMD并尝试了以下方法：

I am trying to install Snowflake JDBC driver according to instructions.
I have downloaded and installed Java from here, then downloaded snowflake-jdbc-3.6.9.jar file from here. When I double-click the file, nothing happens. So I opened CMD and tried this:

java -jar snowflake-jdbc-3.6.9.jar

我收到了 *没有主要清单属性，位于雪花jdbc-3.6.9.jar * 。

打开META-INF\MANIFEST.MF文件时，我确实看到：

I received *no main manifest attribute, in snowflake-jdbc-3.6.9.jar*.
When I open META-INF\MANIFEST.MF file, I do see:

*Manifest-Version: 1.0*

*Main-Class: net.snowflake.client.jdbc.SnowflakeDriver*

到目前为止，我已经使用其他StackOverflow主题的建议了，并且不知道还能尝试什么。我对Java不太了解，我只需要安装此驱动程序，就可以从BI工具连接到Snowflake。我非常感谢您的帮助。

I have gotten this far using suggestions from other StackOverflow topics, and don't know what else to try. I don't know much about Java, I just need to install this driver, so I could connect to Snowflake from a BI tool. I would really appreciate your help.

推荐答案

我想您现在已经安装并运行了。

I presume you got it up and running by now.

但是，正如其他响应者中提到的那样，通过将 .jar 文件复制到计算机中，您已经或多或少安装了该驱动程序。

But as mentioned by one of the other responders, by copying the .jar file to your computer you have already more or less installed the driver.

与 OBDC驱动程序不同，没有 JDBC管理器，它期望 JDBC驱动程序始终需要安装在某个目录中。

Different from OBDC drivers, there is no JDBC manager, which expects that JDBC drivers need always to be installed in a certain directory.

您必须指出

让我们以dBeaver为例，它是 Snowflaker 用户。 （并且可用于 Windows ， Mac 和 Linux ））

Let's take as an example dBeaver, a popular JDBC Query tool among Snowflaker users. (And available for Windows, Mac and Linux)

在可以在 dBeaver ， dBeaver 中使用此驱动程序之前必须知道该驱动程序确实存在并且可以使用。

Before you can use this driver within dBeaver, dBeaver has to be made aware that this driver does exist and can be used.

因此，启动 dBeaver 之后，您首先将dBeaver指向您放置雪花 .jar文件的位置。

So after starting up dBeaver you first point dBeaver to the location where you have put the Snowflake .jar file.

（让我们假设您没有为了我的答案的有用，不想使用预先配置的Snowflake JDBC驱动程序）

(Let's assume that you don't want to use the preconfigured Snowflake JDBC driver for the sake of usefulness of my answer)

因此，您选择New并选择'create new driver'

So you select New and select 'create new driver'

在Windows [Libraries]下，您可以添加文件或文件夹。
选择[添加文件]并指向JDBC .jar文件。

Under the windows [Libraries] you can add a file or a folder. Select [Add File] and point at your JDBC .jar file.

从那时起，您可以使用JDBC驱动程序。

As of then you can use the JDBC driver.

为完整性起见，此处使用与dBeaver中提供的Snowflake JDBC驱动程序不同的其他详细信息：

For completeness are here the other details to use a different Snowflake JDBC driver than the provided one in dBeaver:

[Driver Type:] Snowflake
[Class Name:] net.snowflake.client.jdbc.SnowflakeDriver
[URL Template:] this contains the default connectstring format to use this JDBC driver (So how a connectstring should look like to make a successful connection to Snowflake)

[Default Port:] 443 (should have been preset)

其余应该是自我解释。

这篇关于安装Snowflake JDBC驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！