I'm trying to do a select on a column with special characters in Databricks sql.

I've tried the following

%sql
select ex$col 
from database.table
limit 10;
 
%sql
select `ex$col `
from database.table
limit 10;

They both don't work and will return "ex does not exist. Did you mean the following/ .... "

Is there a way to do this? or is the functionality not currently supported?