please consider this is a "best effort" type of support, we're not able to set up a bigquery account, develop a similar case to what you're seeing and come up with a solution. We need a few weeks to see what's going on here
Nevertheless, do you have cases where you use metabase variables on a bigquerry table ? @dragonsahead
I found the solution in a post from 2021.
Basically, the from-clause should be without Project ID
Maybe this will help others when the time comes.
Thanks for your contributions