argasi / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

Import data Wizard - Validate inputs first #13

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
I would like that the wizard used for importing new data ("Choose job 
template", "Choose destination" .. ... ) validated the inserted data step after 
step, instead of launching a big fail at the end of the entire process.

Fore example, I want to import a csv containing 40 fields. 
I have to put a name for the table, to select the file, then to insert the 
fields names. 
If I select a non existent file (on Cloud Storage), I will have to start again 
since the beginning.
If I insert a wrong number of fields (I have forty of them, there is not much 
space in the text box, I can misspell one of them, or forget a comma, or give a 
wrong type), I will have to start again.

These are very annoying problems.

Original issue reported on code.google.com by a...@faceit.com on 6 Apr 2013 at 4:15

GoogleCodeExporter commented 9 years ago
With complex schema like this, a better option would be to use programmatic 
tools such as 
https://developers.google.com/bigquery/bq-command-line-tool#creatingtablefromfil
e rather than the import wizard.

This would allow you to script your imports, or use your shell environment's 
command line history to make corrections.

Original comment by thomasp...@google.com on 22 Aug 2014 at 5:36