We’ve recently started using some anomaly tests with our elementary install. Apparently, there are tables being created in our development schema. We have a cleanup task on this schema for some compliance, and for some reason these tables require the table name be wrapped in quotes. (We are using snowflake). For example, the tmp test table is named

test_00867c23d2_event_day_of_week_anomalies__anomaly_scores__tmp_20240306232723512815

select * from dev_schema.test_00867c23d2_event_day_of_week_anomalies__anomaly_scores__tmp_20240306232723512815

does not work 👎

select * from dev_schema."test_00867c23d2_event_day_of_week_anomalies__anomaly_scores__tmp_20240306232723512815"

does work. 👍 1. Is elementary doing something when creating this table, that is requiring the name to be wrapped in quotes? 2. What macro/on-run-end is creating this table? If we didn’t need it, can it be disabled with a variable?

It looks you are using Snowflake, and its naming convention is not very obvious. The following names in Snowflake are equivavlent: 1. my_table 2. "MY_TABLE" 3. My_Table 4. MY_TABLE If quoted name contains any lowercase character or non-alphanumeric character, it may be referenced only using quotes. So Elementary creates test table with quotes and lowercase chars, you have to use quoted name