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'