Storage integrations: Case-insensitive name resolution for single-quoted session variables (Pending)¶

When a storage integration is created without double quotes (for example, CREATE STORAGE INTEGRATION my_integration ...), the integration name is stored in uppercase by Snowflake. If a session variable is then set using single quotes to reference that integration (for example, SET storage_int_name = 'my_integration';), the variable value was previously required to be in uppercase to match. This change makes that resolution case-insensitive.

Before the change:

When a storage integration was created without double quotes and its name was referenced through a session variable defined with single quotes, the value in the session variable had to be uppercase to match the integration name. For example, if the session variable was set as SET storage_int_name = 'my_integration';, using $storage_int_name in a SQL statement failed with: SQL compilation error: Integration '"my_integration"' does not exist or not authorized. The workaround was to use uppercase: SET storage_int_name = 'MY_INTEGRATION';.

After the change:

The storage integration name in the session variable is resolved case-insensitively, so SET storage_int_name = 'my_integration'; works regardless of letter case.

Ref: 2300