javascript - Apps script write to Big Query unknown error -

-

this supposed read in csv , write bigquery. when runs, however, nothing written, , there no errors logged. read need write csv , turn octet stream. not sure whether or not compatible google bigquery.

function test(){ try{   var tablereference = bigquery.newtablereference();   tablereference.setprojectid(project_id);   tablereference.setdatasetid(datasetid);   tablereference.settableid(tableid);   var schema = "customer:string, classnum:integer, classdesc:string, csr:string, csr2:string, insurance:string, referralgeneral:string, referralspecific:string, notes:string, inmin:integer, inhr:integer, outmin:integer, outhr:integer, waitmin:integer, waithr:integer, datetimestamp:float, dateyr:integer,datemonth:integer, dateday:integer";   var load = bigquery.newjobconfigurationload();   load.setdestinationtable(tablereference);   load.setsourceuris(uris);   load.setsourceformat('newline_delimited_json');   load.setschema(schema);   load.setmaxbadrecords(0);   load.setwritedisposition('write_truncate');    var configuration = bigquery.newjobconfiguration();   configuration.setload(load);    var newjob = bigquery.newjob();   newjob.setconfiguration(configuration);     var loadr = driveapp.getfilesbyname("test.csv");   var x = loadr.next().getblob();   logger.log(x.getdataasstring());    var d = driveapp.getfilesbyname("test.csv");   var id = d.next().getid();   logger.log(id);   var data = docslist.getfilebyid(id).getblob().getdataasstring();   var mediadata = utilities.newblob(data, 'application/octet-stream');    bigquery.jobs.insert(newjob, project_id, mediadata)   }  catch(error){logger.log("a" + error.message);} }

your sourceformat wrong csv files:

the format of data files. csv files, specify "csv". datastore backups, specify "datastore_backup". newline-delimited json, specify "newline_delimited_json". default value csv.

https://developers.google.com/bigquery/docs/reference/v2/jobs#configuration.load.sourceuris

on other hand think don't need @ load.setsourceuris(uris); since try load local file, , not google cloud storage. check python example https://developers.google.com/bigquery/loading-data-into-bigquery


Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in...
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = ...
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more