It might depend on how your table was created. I was able to get the below to work:

CREATE OR REPLACE TABLE database.special_chars (`ex$col` int);
INSERT INTO database.special_chars VALUES (1);
 
SELECT `ex$col`
FROM database.special_chars
LIMIT 10;