@cubejs-backend/bigquery-driver

Website • Docs • Blog • Slack • Twitter

Cube.js BigQuery Database Driver

Pure Javascript BigQuery driver.

Learn more

Credentials

CUBEJS_DB_BQ_PROJECT_ID=gcp-project-id
CUBEJS_DB_BQ_KEY_FILE=/path/to/key-file.json

Or get base64 version of your key file json using

$ cat /path/to/key-file.json | base64

And then put base64 string in .env:

CUBEJS_DB_BQ_PROJECT_ID=gcp-project-id
CUBEJS_DB_BQ_CREDENTIALS=<base_64_credentials_json>

License

Cube.js BigQuery Database Driver is Apache 2.0 licensed.

Changelog

1.1.8 (2024-12-05)

Bug Fixes

• clickhouse-driver: Replace error cause with string formatting (#8977) (e948856)
• clickhouse-driver: Tune ClickHouse errors: remove SQL, catch ping failure (#8983) (811a7ce)
• cubesql: fix unhandled timestamp unwrapping in df/transform_response (#8952) (4ea0740)
• cubestore: Disable writing cachestore logs by default to reduce use of disk space (#9003) (7ccd607)
• dev_env_setup: Fix incorrect arguments processing and make console output more user-friendly (#8999) (ead97b4)
• dev_env_setup: use relative packages everywhere (#8910) (ae823c9)
• ensure public is in sync with isVisible when using DAP (#8980) (a3ed6ea)
• fix data access policies condition logic (#8976) (47e7897)
• ksql-driver: Kafka, list of brokers (#9009) (31d4b46)
• schema-compiler: fix FILTER_PARAMS to populate set and notSet filters in cube's SQL query (#8937) (6d82f18), closes #9009 #8793
• schema-compiler: Fix incorrect sql generation for view queries referencing measures from joined cubes (#8991) (cd7490e)
• schema-compiler: Fix ungrouped cumulative queries incorrect sql generation (#8981) (82ba01a)
• schema-compiler: Undefined columns for lambda pre-aggregation queries referencing dimensions from joined cubes (#8946) (41b49f4)
• schema-compiler: use query timezone for time granularity origin (#8936) (1beba2d)
• server-core: fix improper requestId retrieval in DAP (#9017) (4e366d3)
• server-core: fix member level access policy evaluation (#8992) (ff89d65)

Features

• cubejs-api-gateway: alternative auth headers (#8987) (eb33d1a)
• databricks-driver: Support for intervals and CURRENT_DATE for sql push down (#9000) (f61afc3)
• duckdb-driver: remove unnecessary installing and loading HttpFS extension (#8375) (0aee4fc)
• firebolt: Automatically start the engine after connection (#9001) (8f45afa)
• pinot-driver: add optional oAuth headers (#8953) (7b1f797)
• sqlplanner: Extract alias logic from the symbols (#8919) (d1b07f1)

Performance Improvements

• cubestore: ProjectionAboveLimit query optimization (#8984) (8a53481)
• cubestore: Update DataFusion pointer to new GroupsAccumulator changes (#8985) (4613628)