Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Name format to create Dataset.


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"
    }
}

1 5 944
5 REPLIES 5