Backticks on Bigquery queries

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