ติดตั้ง npm

npm install --save @google-cloud/bigquery

โค้ด Query

const {BigQuery} = require('@google-cloud/bigquery')

const bigquery = new BigQuery({
    projectId: 'project_id',
    keyFilename: 'path_to_serviceaccount_file.json'
})


const sqlQuery = `SELECT * FROM \`project.dataset.table\` LIMIT 5`
const options = {
    query: sqlQuery
}
const [rows] = await bigquery.query(options)


rows.forEach(row => {

    // row object

})