Can not open information link created using snowflake JDBC connection

Can not open information link created using snowflake JDBC connection

book

Article ID: KB0082200

calendar_today

Updated On:

Products Versions
Spotfire Analyst All supported versions

Description

Information links created using snowflake JDBC connection may throw the following error while trying to open them in Spotfire. 

===============
InformationModelServiceException at Spotfire.Dxp.Services:
Failed to execute query: No active warehouse selected in the current session. Select an active warehouse with the 'USE WAREHOUSE' command.

===============

Issue/Introduction

Can not open information link created using snowflake JDBC connection

Environment

All supported environments

Resolution

To resolve this error, specify the required warehouse in the 'Open Session Commands' with in Datasource Edit screen.

====================================
USE WAREHOUSE <warehouse_identifier>
====================================
Here, the warehouse_identifier value is the name of the warehouse.
Example: USE WAREHOUSE mywarehouse

This command specifies the current warehouse for the current user session.
A warehouse must be specified for a session and the warehouse must be running before DML statements and queries can be executed in the session.

If the data source is already created without specifying this value, the following steps should be performed.
=> Select the data source from Information Designer
=> Right click and select "Edit"
=> Enter the value in "open session commands" field in the format mentioned above
=> Save the data source

Additional Information

https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html