Table "invoices" must be qualified with a dataset (e.g. dataset.table)

In some queries I write, I get this error:

"Table "invoices" must be qualified with a dataset (e.g. dataset.table)."

In other queries for the same table, I do not get this error.

What does it mean, please?

@haj Please provide more detailed information regarding what you are doing when the error occurs.

See the image below. I just created that query just now. invoices definitely is a table in my Retool DB.

Your resource is BigQuery so you need to define the dataset in the query as the error suggests. The table is invoices but what is the dataset name?

Thank you. I wonder why Retool would choose that as the default resource. All my other queries are the Retool Database. Problem solved. Thanks for the attention to detail.