Running into Syntax Error because my assigned project ID starts with True

[heycaryn]

My assigned by BQ project ID is true-episode-#.  The exact error states "Syntax error: Unexpected keyword TRUE at [5:25]" - where the name of my project is.  Is there a way around this? Can I somehow isolate my project ID so that it is not reading it as the TRUE statement so I don't continue to run into this problem?

Edit: Now I'm trying to do something that does not have my project ID, and the error "Not found: Dataset true-episode-#:transaction was not found in location US" is appearing.  I'm not sure if it is related or not, but I'm kind of stuck in my course right now.  My location is set to US West, OR...

[caryna]

Hi @heycaryn,

Welcome to the Google Cloud Community!

The error “Unexpected keyword TRUE” occurs because “true” is a reserved SQL word. Since your project-id starts with “true”, there is a possibility that BigQuery is reading your project-id as a boolean true keyword. To resolve this, try enclosing the project-id in backticks (`):

SELECT * FROM `project_name.dataset_id.table_id`

project_name: the project name you are working on. 

dataset_id: your dataset name.

table_id : your table name.

For the error “Not found: Dataset true-episode-# was not found in location US”,  it’s possible that the dataset has not been created, it might be misspelled, or the dataset location might not be set to US.

To resolve this, follow these steps:

• Verify if the dataset exists. In the left panel under Explorer, check for the dataset. For quicker results, you can also search for the specific dataset. An example screenshot is provided below:

• If not, refer to the documentation on creating datasets using the Google Cloud Console for guidance. Before you start, ensure you have the necessary permissions to create a dataset. 
• Ensure that you haven't misspelled the dataset name in your query.
• To check the location of an existing dataset, simply select the dataset. An example screenshot is provided below:

Note: The dataset location cannot be changed once the dataset is created.

I hope the above information is helpful.