Run Query

import { BigQuery } from "@google-cloud/bigquery";

type Gcloud = {

  type: string;

  project_id: string;

  private_key_id: string;

  private_key: string;

  client_email: string;

  client_id: string;

  auth_uri: string;

  token_uri: string;

  auth_provider_x509_cert_url: string;

  client_x509_cert_url: string;

  universe_domain: string;

};

export async function main(resource: Gcloud, query: string) {

  const bigQueryClient = new BigQuery({

    credentials: resource,

    projectId: resource.project_id,

  });

  const [job] = await bigQueryClient.createQueryJob({

    query,

  });

  const [rows] = await job.getQueryResults();

  return rows;

}