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

What is the table name format allowed?

As  we have created table name with hyphen(-) , when we try to get data from it we are facing Bad Request (status code 400)  in POSTMAN  , Please help here.

Table name is  integ-parti-3519

appflowpersiste_0-1709635460484.png

 

 

0 2 517
2 REPLIES 2

Hi,
The table ID format in BigQuery is typicallyproject_id:dataset_id.table_id
However, for API requests, this often needs to be specified as 
projects/projectId/datasets/datasetId/tables/tableId.

Hope this helps

If the table name contains special characters (which might include the "-" character) surround the name in back-ticks ... try:

select id, name from `bbq_dataset1.integ-parti-3519`