bq.js

const bigquery = require('@google-cloud/bigquery')({
    projectId: 'your-project-id',
    keyFilename: 'key.json'
});

const sqlQuery = "SELECT total_amount, pickup_datetime, trip_distance FROM 'nyc-tlc.yellow.trips' ORDER BY total_amount DESC LIMIT 1;";
    
const options = {
        query: sqlQuery,
        timeoutMs: 10000, 
        useLegacySql: false, 
      };

 bigquery
 .query(options)
 .then(results => {
   const rows = results[0];
   console.log('Rows:');
   rows.forEach(row => console.log(row));
   })
 .catch(err => {
        console.error('ERROR:', err);
 });`