0

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?

Improve this question
2

1 Answer 1

Reset to default
1

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

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Thanks. I've opened an issue. issuetracker.google.com/issues/152293190
I hope they fix it quickly :) If this answer helped you addressing you problem somehow, consider accepting or upvoting

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.