async function createTable() {
  const bigquery = new BigQuery({
    apiEndpoint: 'http://0.0.0.0:9050/',
    projectId: 'gccstart'
  })
  
  const datasetId = 'my_dataset';
  const tableId = 'my_table';
  
  const options = {
    location: 'US'
  }

  // Create a new table in the dataset
  const [table] = await bigquery
    .dataset(datasetId)
    .createTable(tableId, options)

  console.log(Table ${table.id} created.);
}

async function createDataset(){
  const bigquery = new BigQuery({
    apiEndpoint: 'http://0.0.0.0:9050',
    projectId: 'gccstart'
  })

  const datasetId = 'my_dataset'

  const [dataset] = await bigquery.createDataset(datasetId)
  console.log(`Dataset ${dataset.id} created.`)
}

async function populateTable() {
  const bigquery = new BigQuery({
    apiEndpoint: 'http://0.0.0.0:9050',
    projectId: 'gccstart'
  })

  const datasetId = 'my_dataset';
  const tableId = 'my_table';

  const metadata = {
    sourceFormat: 'NEWLINE_DELIMITED_JSON',
    schema: {
        fields: [
        {name: 'name', type: 'STRING'},
        {name: 'id', type: 'STRING'},
        ],
    },
    location: 'US',
  };

  const filePath = path.join('bqvalues.json')
  await bigquery
    .dataset(datasetId)
    .table(tableId)
    .load(filePath, metadata)
}

  await bigquery.dataset(datasetId).table(tableId).insert([{
    policy: 'test',
    uuid: 'uuid',
    timestamp: new Date(),
    result: {
      id: 'result'
    },
    input: {
      id: 'input'
    },
  }])

From:

    fields.push({name: 'result'   , type: 'JSON',   mode: 'REQUIRED'})
    fields.push({name: 'input'    , type: 'JSON',   mode: 'REQUIRED'})

    const result = { result: 'result'}
    const input  = { input: 'input'}
    
    const decision = {
      policy: 'test',
      uuid: uuidv4(),
      timestamp: new Date(),
      result: result,
      input: input
    }   

    fields.push({name: 'result'   , type: 'STRING',   mode: 'REQUIRED'})
    fields.push({name: 'input'    , type: 'STRING',   mode: 'REQUIRED'})

    const result = JSON.stringify({ result: 'result'})
    const input  = JSON.stringify({ input: 'input'})

    const decision = {
      policy: 'test',
      uuid: uuidv4(),
      timestamp: new Date(),
      result: result,
      input: input
    }