Skip to content

Snowflake 凭据#

¥Snowflake credentials

你可以使用以下凭据验证以下节点：

¥You can use these credentials to authenticate the following nodes:

先决条件#

¥Prerequisites

创建 Snowflake 账户。

¥Create a Snowflake account.

支持的身份验证方法#

¥Supported authentication methods

  • 数据库连接

¥Database connection

相关资源#

¥Related resources

请参阅 Snowflake API 文档 和 SQL 命令参考 获取有关服务的更多信息。

¥Refer to Snowflake's API documentation and SQL Command Reference for more information about the service.

使用数据库连接#

¥Using database connection

要配置此凭据，你需要：

¥To configure this credential, you'll need:

  • 账户名称：你的账户名是 Snowflake URL 中 https:// 和 snowflakecomputing.com 之间的字符串。例如，如果你的 Snowflake 账户 URL 为 https://abc.eu-central-1.snowflakecomputing.com，则你的账户名称为 abc.eu-central-1。

¥An Account name: Your account name is the string of characters located between https:// and snowflakecomputing.com in your Snowflake URL. For example, if the URL of your Snowflake account is https://abc.eu-central-1.snowflakecomputing.com then the name of your account is abc.eu-central-1.

  • 数据库：输入凭据应连接的 database 的名称。

¥A Database: Enter the name of the database the credential should connect to.

  • 仓库：输入连接后会话要使用的默认虚拟 warehouse 的名称。n8n 使用此仓库执行查询、加载数据等操作。

¥A Warehouse: Enter the name of the default virtual warehouse to use for the session after connecting. n8n uses this warehouse for performing queries, loading data, and so on.

  • 用户名

¥A Username

  • 密码：

¥A Password

  • 架构：输入连接后要使用的 schema。

¥A Schema: Enter the schema you want to use after connecting.

  • 角色：输入连接后要使用的安全级别 role。

¥A Role: Enter the security role you want to use after connecting.

  • 客户端会话保持活动状态：默认情况下，客户端连接通常会在最近一次查询执行后三到四个小时超时。启用此设置会将 clientSessionKeepAlive 参数设置为 true。服务器将无限期地保持客户端连接，即使连接不执行任何查询。

¥Client Session Keep Alive: By default, client connections typically time out three or four hours after the most recent query execution. Turning this setting on sets the clientSessionKeepAlive parameter to true: the server will keep the client's connection alive indefinitely, even if the connection doesn't execute any queries.

有关这些设置的更多信息，请参阅 会话命令。

¥Refer to Session Commands for more information on these settings.