index.js

// Import the Google Cloud client library using default credentials
const {BigQuery} = require('@google-cloud/bigquery');
const bigquery = new BigQuery();

async function query() {
    const query = "SELECT * FROM \`$TABLE_NAME\` LIMIT 1000";
    const options = {
        query: query,
        // Location must match that of the dataset(s) referenced in the query.
        location: 'europe-west4',
    };
    const [job] = await bigquery.createQueryJob(options);
    console.log(`Job ${job.id} started.`);

    const [rows] = await job.getQueryResults();
    console.log('Rows:');
    rows.forEach(row => console.log(row));
}

query();