Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function insertRowsInBigQuery(){
- var projectId = 'xxx';
- var spreadsheet = SpreadsheetApp.getActive();
- var sheet = spreadsheet.getSheetByName("EPC");
- var data = sheet.getRange(2, 1, sheet.getLastRow() - 1, 2).getValues();
- var sqlData = "INSERT INTO ean.eanToAnalyze (EPC, EAN) VALUES (";
- for (i = 0; i < data.length; i++){
- if (i > 0) {
- sqlData += ",(";
- }
- for (j = 0; j < data[0].length; j++){
- sqlData += "'" + data[i][j] + "'";
- if (j < data[0].length -1){
- sqlData += ",";
- } else {
- sqlData +=")";
- }
- }
- }
- var request = {
- query: sqlData,
- writeDisposition: 'WRITE_TRUNCATE'
- };
- var queryResults = BigQuery.Jobs.query(request, projectId);
- var jobId = queryResults.jobReference.jobId;
- // Check on status of the Query Job.
- var sleepTimeMs = 500;
- while (!queryResults.jobComplete) {
- Utilities.sleep(sleepTimeMs);
- sleepTimeMs *= 2;
- queryResults = BigQuery.Jobs.getQueryResults(projectId, jobId);
- }
- Logger.log(queryResults);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement