CODEWITHSUNDEEP
google-bigquery
user836107
user836107

Reputation: 189

Bigquery: data export/import to/from cloud storage fails

Job Log for Extract 12:02pm publicdata:samples.shakespearetogs://OfficeTest/Shakes.csv Errors: Backend error. Job aborted. Job ID: job_8373291c210f4d04aab9ee04efa3559b Start Time: 12:02pm, 22 Aug 2012 End Time: 12:03pm, 22 Aug 2012 Source Table: publicdata:samples.shakespeare Source URI: gs://OfficeTest/Shakes.csv

Job Log for import from GS Errors: Unable to read source URI: gs://OfficeTest/FLAT_CMPL.txt Job ID: job_900a741b2eab4f95924a293110fa562f Start Time: 9:59am, 22 Aug 2012 End Time: 9:59am, 22 Aug 2012 Destination Table: 726753267556:Test2.test Source URI: gs://OfficeTest/FLAT_CMPL.txt

I was able to upload a simple csv file and it worked. Am I missing any setting??

Upvotes: 0

Views: 909

Answers (1)

Jordan Tigani
Jordan Tigani

Reputation: 26637

OfficeTest is not a valid bucket name -- according to this page, bucket names must be all lower-case. Try again with gs://officetest/...

I'll fix the BigQuery validation code so that we flag this an error earlier.

Upvotes: 1

Related Questions