Skip to main content

Managing Case Sensitivity in Snowflake and Coalesce

Issue​

  • Environment Setup: Snowflake environment configured to ignore case sensitivity.
  • Problem: Coalesce adds quotation marks around column names if they are not in uppercase, which enforces case sensitivity in Snowflake.

Solution​

  1. Add the QUOTED_IDENTIFIERS_IGNORE_CASE to your deployment parameters. Review the Snowflake Parameters documentation.

    Quoted_identifier_ignore_case

  2. To each node, add ALTER SESSION SET QUOTED_IDENTIFIERS_IGNORE_CASE = {{parameters.Quoted_identifier_ignore_case}}in the Pre-SQL for each node that needs it.

    The image shows a database configuration interface for a staging table (STG_CUSTOMER) with columns, their transformations, data types, and sources listed. On the right, the configuration panel includes settings like Multi Source, Truncate Before, and Enable Tests, along with a Pre-SQL section containing a session alteration command. The interface includes buttons for validation, creation, and running of data fetching at the bottom.