BigQuery dialect for Knex.js
npm install knex-bigqueryBigQuery dialect for building and executing queries using Knex.js.
This project is no longer maintained
This project was a quick POC to check whether or not it will be possible to migrate existing knex-postgres codebase to knex-bigquery without too much trouble.
Although it was a success, we decided to go with a different approach.
``bash`Yarn:
yarn add knex-bigqueryNPM:
npm install knex-bigquery
`js
const { BigQueryClient } = require('knex-bigquery');
const knex = require('knex')({
client: BigQueryClient,
connection: {
projectId: 'bigquery-playground',
keyFilename: '/Users/dumbledore/playground-credentials.json'
},
pool: { min: 0, max: 5 }
});
(async () => {
const commonNames = await knex('bigquery-public-data.usa_names.usa_1910_2013')
.select('name', 'gender')
.sum('number as total')
.groupBy('name', 'gender')
.orderBy('total', 'desc')
.limit(3);
console.log(commonNames);
await knex.destroy();
})();
// [
// { name: 'James', gender: 'M', total: 4924235 },
// { name: 'John', gender: 'M', total: 4818746 },
// { name: 'Robert', gender: 'M', total: 4703680 },
// ]
``
Connection settings are passed to the BigQuery client library constructor.
Make sure you pass a valid properties combination.