How to set ResultSet to be ColumnCaseInsensitive

[snowflakedb]

How to set ResultSet to be ColumnCaseInsensitive

[howryu]

This is a parameter that is not exposed to user, but only controlled by Snowflake. So if you want to enable it, please file a support ticket and support will enable the parameter for your whole account.

props.setProperty actually worked for parameters that is exposed to end users. i.e. TIMESTAMP_OUTPUT_FORMAT. Once you put the parameters in properties, it will be sent to server along with login request. And response from the server will have an updated value.

As for why don't we enable column insensitive search by default is because Snowflake is able to return both upper case and lower case identifier.

select col1 as "a", col2 as "A" from t will return two columns with metadata saying column names are a adn A, enabling the parameter by default will only return first column.

[ooasis]

I actually saw JDBC_RS_COLUMN_CASE_INSENSITIVE=TRUE being sent to the server. However, the server does not honor it and still returns JDBC_RS_COLUMN_CASE_INSENSITIVE=FALSE.

Are you saying that we cannot programmatically change it?

[howryu]

Right, we did not allow users to change it. You need to file a ticket to enable it.

[mohanrao]

@howryu I am stuck on this. The setting is being sent to the server but not working. What to do ?

[ooasis]

You need to ask your account manager to change it.

[mohanrao]

@hsun-cnnxty It is not a right approach. It will affect all other applications.

[stiradrian]

Use CLIENT_RESULT_COLUMN_CASE_INSENSITIVE in the connection string:

jdbc❄️//${snowflake.account}.snowflakecomputing.com/?warehouse=${snowflake.warehouse}&db=${snowflake.database.name}&schema=${snowflake.schema}&CLIENT_RESULT_COLUMN_CASE_INSENSITIVE=true