cube-js/cube

How can I set maximumBytesBilled on BigQuery?

Open

#3,668 opened on Nov 16, 2021

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Rust (19,563 stars) (1,965 forks)batch import
help wanted

Description

Problem

I want set maximumBytesBilled when query call. https://cloud.google.com/bigquery/docs/best-practices-costs#api_1

Can I set maximumBytesBilled option on cubejs-bigquery-driver? I can't found how to set query job options.

Related Cube.js schema

Related Cube.js generated SQL

Contributor guide

Tech stack
javascripttypescriptnodejssql
Domain
backenddatabasecloud
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
BigQueryCube.jsJavaScriptSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
30
Research direction
Investigate the cubejs bigquery driver source code (likely in packages/cubejs bigquery driver) to see how query options are currently passed to the BigQuery client. Check the BigQuery Node.js documentation for setting maximumBytesBilled. The implementation should add a new option in the driver's query method that passes this parameter to the BigQuery API. Review any existing comments on this issue for maintainer feedback.
How can I set maximumBytesBilled on BigQuery? · cube-js/cube#3668 | Good First Issue