googleapis / googleapis/google-cloud-python

read_gbq: add mechanism to ensure BQ storage API usage

Aperta
#14,472 2 commenti 1 reazione 1 assegnatario Assegnata a @TrevorBergeron Vedi su GitHub
api: bigquery type: feature request
Lingua principale
Python
Stelle
5.4k
Fork
1.8k
Merge medio
3g 4h
PR unite (30g)
122

Descrizione

**Assumption**: there is currently no supported way to force `read_gbq` to use the BQ storage API. I'd be happy to be corrected if I missed something!

**Is your feature request related to a problem? Please describe.**

I have cases where `read_gbq`'s heuristic chooses the JSON API, when I want the storage API. This is most noticeable for me on medium sized tables, which might take 5-20 seconds to load via the JSON API (comparatively these were much faster via the storage API). For many of my use cases: to make interactive use cases more bearable, I am very willing to pay the additional storage API cost.

**Describe the solution you'd like**

A parameter to read_gbq which forces the usage of the BQ storage API (including raising an error if the necessary deps are not available to do so). I won't try to be prescriptive about the details, though I'll note that the desired behavior I've described is what I expected from `use_bqstorage_api`, based on the name. From my understanding of the current behavior, `allow_bqstorage_api` is maybe more accurate.

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.