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

Queries and Resources
1

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?

2

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

3

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

Screenshot by Dropbox Capture
Screenshot by Dropbox Capture1038×1286 98.7 KB

4

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?

5

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.