I Would like to know that, does Dataset name accepts only numbers or alphanumerical or alphabets?
Case 1: only with number
I have created the dataset name with numbers only, when I am calling that dataset query through API it is giving me error.
Case 2: with alphanumerical
I have created the dataset name with alphanumerical, and it is fetching data from that dataset table.
Case 3: with alphanumerical but start with number
I have created the dataset name with the alphanumerical and that alphanumerical start with numbers, when I am calling that dataset query through API it is giving me error.
Please find below request and response
Request:
https://bigquery.googleapis.com/bigquery/v2/projects/p***al-tr**il-35****9/queries
Query :
1) SELECT * from 9gsh693.ga_sessions_202402032
2) SELECT * from 9897693.ga_sessions_202402002
Both the query giving same error response
Response :
{
"error": {
"code": 400,
"message": "Encountered \" \"FROM\" \"from \"\" at line 1, column 10.\nWas expecting:\n <EOF> \n ",
"errors": [
{
"message": "Encountered \" \"FROM\" \"from \"\" at line 1, column 10.\nWas expecting:\n <EOF> \n ",
"domain": "global",
"reason": "invalidQuery",
"location": "q",
"locationType": "parameter"
}
],
"status": "INVALID_ARGUMENT"
}
}