CODEWITHSUNDEEP
google-bigquery
GTY
GTY

Reputation: 427

Source Data Partitioning is disabled in BigQuery

I am trying to import an external table that has hive partitioned information on it in GCS. The structure of file has the following format. 

gs://bucket/events/year=2020/month=03/day=23/hour=0/
gs://bucket/events/year=2020/month=03/day=23/hour=1/

The files under these folders are in JSON format.

When I try to create the table in BigQuery, the UI editor doesn't allow me to enter Source URI information. The option comes up as follows.

enter image description here

Does anyone know what could be the issue around this? Why is the source URI information coming up disabled? Is it something to do with permissions or the way partitions are created in the structure above?

Upvotes: 0

Views: 501

Answers (1)

rmesteves
rmesteves

Reputation: 4085

Everything is fine in your partition format. Besides that, the problem is not related to permissions (even if you have some permission problem). I tried to reproduce your issue and found the same problem. As it was working fine some days ago, the problem is on Big Query's new release and not on your side.

When the box Source data partitioning is marked you should see:

enter image description here

If you think this problem affects you and other persons I encourage you to create a public issue reporting this problem.

I hope it helps

Upvotes: 1

Related Questions