to be clear. i am on team "do not use special characters in table or column names", It is snowflake they have " select metadata$filename, metadata$file_row_number, t.$1, t.$2 from @mystage1 (file_format => myformat) t; " syntax in copy command which may or may not be in current dataset also snowflake has https://docs.snowflake.com/en/sql-reference/functions-system.html systems functions which use $