Checkmark

BigQuery Tutorial Code Snip 3

Jul 2nd, 2013
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. // Returns a Data Table from a query's result values and schema
  2. function buildDataTable(resultValues, resultSchema) {
  3.  
  4. var dataTable = Charts.newDataTable();
  5. for (var i = 0; i < resultSchema.getFields().length; i++) {
  6. column = resultSchema.getFields()[i];
  7. columnName = column.getName();
  8. columnType = (column.getType() == 'INTEGER' || column.getType() == 'FLOAT')
  9. ? Charts.ColumnType.NUMBER : Charts.ColumnType.STRING;
  10.  
  11. dataTable.addColumn(columnType, columnName);
  12. }
  13.  
  14. for (var j = 0; j < resultValues.length; j++) {
  15. dataTable.addRow(resultValues[j]);
  16. }
  17.  
  18. dataTable.build();
  19. return dataTable;
  20. }
Advertisement
Add Comment
Please, Sign In to add comment