Source freshness with mixed casing in Snowflake

Help
1

The problem I’m having

I want to use the source freshness test on a column with both upper and lowercase letters lets say: LastLoaded. No matter what i do, I can’t get it to work. Ive tried:

loaded_at_field: LastLoaded
loaded_at_field: ‘LastLoaded’
loaded_at_field: “LastLaded”.

It works after renaming the column to be upper or lowercase only.

No matter what I do, I end up with an: invalid identifier error.

The context of why I’m trying to do this

I want to test my source freshness, but I have no control over the use of lower/uppercase because of the software I use for the loading process.

What I’ve already tried

Ive tried:

loaded_at_field: LastLoaded
loaded_at_field: ‘LastLoaded’
loaded_at_field: “LastLoaded”.

Nothing works, manually renaming the column in snowflake to be all lower or uppercase does work.

Some example code or error messages

17:34:37  Database Error in source companies (models\staging\_sources.yml)
17:34:37    000904 (42000): SQL compilation error: error line 2 at position 10
17:34:37    invalid identifier 'LASTLOADED'
2

I used loaded_at_field: cast(“_fivetran_synced” as timestamp_ntz).
This generates following sql :
select
max(cast(“_fivetran_synced” as timestamp_ntz)) as max_loaded_at,
convert_timezone(‘UTC’, current_timestamp()) as snapshotted_at
from events