Page Comparison

...

example1:

{
        "name": "BigQuery",
          "properties": {
            "referenceName": "bigquery",
            "projectId": "vernal-project1",
            "tempBuketPath": "gs://bucketName.datasetName/tableName",
            "jsonFilePath": "/path/to/jsonkeyfile",
            "InputTableId": "vernal-project1:babynames.names_2014",
            "outputSchema": "name:string,count:int"
          }
        }
      }

This source will read the vernal-project1:babynames.names_2014 table, download the whole table to gs://bucketName.datasetName/tableName, and then get the data from there.

example2:

...

Code Block
language xml
{ "name": "BigQuery", "properties": { "referenceName": "bigquery", "projectId": "vernal-project1", "tempBuketPath": "gs://bucketName.datasetName/tableName", "jsonFilePath": "/path/to/jsonkeyfile", "importQuery":"SELECT name as babyName, count as nameCount FROM [vernal-project1:babynames.names_2014] ORDER BY count DESC LIMIT 3", "InputTableId": "vernal-project1:babynames.blankTable", "outputSchema": "babyName:string,babyCount:int" } } }

 

Before running this source, user should create a blank table with schema : {babyname:string, babyCount:int}. File in r example, make this blank table in vernal-project1:babynames.

...