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:
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.
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.
Nothing works, manually renaming the column in snowflake to be all lower or uppercase does work.
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'