Why Do Snowflake Schema Names Use Different Casing?

Question

Why do some connections create uppercase schema names in Snowflake while others create lowercase schema names, even when the schema names are the same in Fivetran?

Environment

Destination: Snowflake

Answer

The schema name in Snowflake depends on the Destination names option you select when creating the connection:

• Fivetran naming uses unquoted identifiers. Snowflake stores unquoted schema names as uppercase. For example, google_sheets becomes GOOGLE_SHEETS.
• Source naming uses quoted identifiers. Snowflake preserves the schema name as written. For example, google_sheets remains google_sheets.

Therefore, two connections can display the same schema name in Fivetran but create schemas with different casing in Snowflake.

To check which naming option a connection uses:

1. In Fivetran, go to the relevant connection page.
2. Select the Settings tab.
3. Click Edit Connection.
4. Check the Destination names setting.

You can only change the Destination names setting before the connection's initial sync begins. After the initial sync starts, you must create a new connection to use a different setting.