Problem:
When loading an Information Link containing a TIMESTAMPTZ data type column, users may encounter the following error:
com.spotfire.ws.api.common.InformationModelWebServiceException: Failed to execute query: Unsupported JDBC data type in query result: TIMESTAMPTZ
This error occurs because the TIMESTAMPTZ data type is not supported for JDBC Snowflake data sources in Spotfire.
Resolution:
To resolve this issue, we can cast the TIMESTAMPTZ columns to DATETIME. Follow these steps:
1. Identify all column elements in your Information Link that are connected to Snowflake and have the TIMESTAMPTZ data type.
2. For each identified column element, modify the Expression as follows:
Cast(%1 AS DATETIME)
3. Change the Data Type of these column elements to Datetime.
4. Test the Information Link to verify that the error no longer occurs.
Note: This workaround allows you to use the data, but be aware that some timezone information may be lost in the conversion process. Ensure that this change doesn't negatively impact your data analysis.