BigQuery Data Transfer Service - Invalid Table Name

0
votes

I am trying to set up a new Data Transfer Service from Cloud Storage to a BigQuery destination table. But the GCP console states that the name is invalid for an existing BQ table. Is this a bug?

For example, I would expect to be able to enter one of these table names for Destination Table, but the only ones that work are those without hyphens.

enter image description here

enter image description here

Per the documentation, the table name should be valid.

Table naming

When you create a table in BigQuery, the table name must be unique per dataset. The table name can:

Contain up to 1,024 characters.
Contain Unicode characters in category L (letter), M (mark), N (number), Pc (connector, including underscore), Pd (dash), Zs (space).

For more information, see General Category.

For example, the following are all valid table names: table-01, ग्राहक, 00_お客様, étudiant.

Update: Bug report submitted to Google.

1
google-cloud-platformgoogle-bigquery
It seems to be a bug. – Diego Queiroz
are you sure that you haven't non printable character at the beginning or the end of your table name? A space for example. – guillaume blaquiere
quite sure that there are no extra characters – smoore4

1 Answers

0
votes

I'm quite sure BQ table names used to not allow hyphens in their name (id) but apparently it has changed and now we can use hyphens.

So maybe data transfer has not updated its destination table validator and continued to refuse hyphens in tables name.