Skip to main content

Google BigQuery

Google BigQuery is an enterprise data warehouse that allows you to store and query massive datasets at high speed using Google's infrastructure


Credential configuration

The projectId corresponds to the project ID from the Google Developer's Console.

The credentials field of the JSON corresponds to a JSON key of the service account. This key is downloaded as a JSON file when you create it. It should be something like this:

"type": "service_account",
"project_id": "PROJECT_ID",
"private_key_id": "KEY_ID",
"private_key": "-----BEGIN PRIVATE KEY-----\nPRIVATE_KEY\n-----END PRIVATE KEY-----\n",
"client_email": "SERVICE_ACCOUNT_EMAIL",
"client_id": "CLIENT_ID",
"auth_uri": "",
"token_uri": "",
"auth_provider_x509_cert_url": "",
"client_x509_cert_url": ""

If you don't have one, create a service account and then, a JSON key for that service account.


Ensure to grant permissions over BigQuery to this service account.

Here is an example of a filled credential configuration form in YepCode:

Google BigQuery Snippets available in YepCode editor


The title is the triggering text for YepCode to autocomplete the script.


New integration from credential
const googleBigQueryClient = yepcode.integration.googleBigQuery("credential-slug");
New integration from plain authentication data
const { BigQuery } = require("@google-cloud/bigquery");

const googleBigQueryCredentials = {
projectId: "YepCode",
credentials: {
type: "service_account",
project_id: "yepcode",
private_key_id: "XXXXX",
private_key: "-----BEGIN PRIVATE KEY-----\nx\n-----END PRIVATE KEY-----",
client_email: "",
client_id: "1234567890",
auth_uri: "",
token_uri: "",
auth_provider_x509_cert_url: "",
client_x509_cert_url: "",

const googleBigQueryClient = new BigQuery(googleBigQueryCredentials);

Create a Dataset

Create a dataset
// Specify the geographic location where the dataset should reside
const options = {
location: "dataset-location",

const [dataset] = await googleBigQueryClient.createDataset("dataset-id", options);
console.log(`Dataset ${} created.`);

List Datasets

List datasets
// Lists all datasets in current project
const [datasets] = await googleBigQueryClient.getDatasets();
datasets.forEach(dataset => console.log(;

Delete a Dataset

Delete a dataset
// Create a reference to the existing dataset
const dataset = googleBigQueryClient.dataset("dataset-id");

await dataset.delete({force: true});
console.log(`Dataset ${} deleted.`);

Query to a Dataset

Query to a dataset
const query = "your-SQL-query";

// For all options, see
const options = {
query: query,
// Location must match that of the dataset(s) referenced in the query.
location: "dataset-location",

// Run the query as a job
const [job] = await googleBigQueryClient.createQueryJob(options);
console.log(`Job ${} started.`);

// Wait for the query to finish
const [rows] = await job.getQueryResults();

// Use the result