Case Sensitivity in Snowflake¶
Understanding how Snowflake handles case sensitivity is essential when configuring Privacera policies and working with database objects.
Default Behavior: Unquoted Identifiers¶
By default, Snowflake interprets unquoted identifiers as uppercase, regardless of how they are typed.
SQL | |
---|---|
Preserving Case: Quoted Identifiers¶
When you use double quotes ("), Snowflake preserves the exact case you specify:
Impact on Privacera Policies¶
When creating Privacera policies for Snowflake resources, consider:
Policy Resource Names
- Unquoted Resources: Use uppercase names in policies (e.g.,
MY_TABLE
,CUSTOMER_NAME
) - Quoted Resources: Use exact case as defined in Snowflake (e.g.,
My_Table
,Customer_Name
) - Consistency: Ensure your naming convention is consistent across your organization
Best Practice
- Stick to one naming convention throughout your organization
- Most organizations use uppercase for simplicity with unquoted identifiers
- Document your naming standards for policy creators
- Prev Connector Guide