ติดตั้ง 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
})