我在尝试通过Jitterbit云工作室连接到Snowflake时收到以下错误:
错误
错误代码:
snowflake07
堆栈跟踪:
Error executing get activity. ,Stack Trace: org.jitterbit.connector.sdk.exceptions.ActivityExecutionException: Error executing get activity.
at org.jitterbit.connector.snowflake.activities.GetActivity.execute(GetActivity.java:94)
...
at java.lang.Thread.run(Thread.java:748)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
The integration is configured in Jitterbit but not sure what setting I need to update in Snowflake to make a GET call.
Or is there a way to use the "USE WAREHOUSE" command in Jitterbit before connecting to Snowflake?
Snowflake 需要"计算"资源来运行查询,这些计算资源称为仓库。 大多数客户端工具都允许您设置登录/配置参数,这是它们设置用于计算的仓库的位置。
如果 Jitterbit 不允许这样做(尽管我认为它是 JDBC,所以它应该(,也许您可以简单地为登录的用户设置默认计算仓库,为此您可以发出 ALTER USER 命令,如下所示:
ALTER USER your_user_id_here SET DEFAULT_WAREHOUSE = your_warehouse_name;
https://docs.snowflake.net/manuals/sql-reference/sql/alter-user.html
为用户设置默认仓库很可能会让您解决最初的连接问题。