IBM Support

SNOWFLAKE_16 - describe warehouse {} failed: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: syntax error line 1 at position {} unexpected '{}'

Troubleshooting


Problem

In Snowflake Executor stage, there was an issue with using special characters to define Warehouse property in Queries tab.

Symptom

In Data Collector, validation fails at Snowflake Executor stage with the error code SNOWFLAKE_16. For instance:

SNOWFLAKE_16 - describe warehouse DEMO-WH failed: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: syntax error line 1 at position 29 unexpected '-'. : Warehouse

Resolving The Problem

Starting from Data Collector 5.11.0 and above, users are now able to use special characters in the Warehouse property. There is also a new property called “Case Sensitive” which is disabled by default in the pipeline. Note that if user wants to use warehouse name with special characters in SQL Queries property, it must be placed inside double quotes.

If needed, user can open a ticket with Support to request for a patch (from version 5.8.x to 5.10.x only). The patch will also contain the fix for this issue and add the new “Case Sensitive” property.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
15 March 2025

UID

ibm17186132

Page Feedback