i have this query thats tun perfectly on bigquery console
SELECT * FROM `fancy-project-name.dataset.table_name`
my problem is that in retool i got an error: syntax error at or near "`"
if i remove the backtick then i got: syntax error at or near "-"
caused by the -
in the project name
and for last, if i remove the project name fancy-project-name
, then i got: relation dataset.table_name does not exist
so iam pretty stuck on this