python-bigquery-pandas

python-bigquery-pandas copied to clipboard

Thanks for stopping by to let us know something could be better! **PLEASE READ**: If you have a support contract with Google, please create an issue in the [support console](https://cloud.google.com/support/)...

codingskynet

ArrowTypeError: Expected a string or bytes dtype, got uint8 when running to_gbq with uint8

4

#### Environment details - OS type and version: Ubuntu 20.04.3 LTS - Python version: 3.7.12 - pip version: 22.3.1 - `pandas-gbq` version: 0.17.9 #### Steps to reproduce 1. Create a...

wnojopra

Support JSON data type

3

First of all: Thank you for maintaining this project, it really is a nice addition to pandas! **Is your feature request related to a problem? Please describe.** GBQ supports[ the...

tilschuenemann

Please run pip check on the "conda" based tests

1

I noticed in https://github.com/conda-forge/pandas-gbq-feedstock/pull/47 that we don't have the necessary version of google-cloud-bigquery-storage on conda-forge, but our conda-based tests were still passing. We should catch when our dependencies need to...

tswast

The BigQuery Storage API accepts a `row_restriction` parameter. It'd be nice to be able to plumb that through to the API. See: https://cloud.google.com/bigquery/docs/reference/storage/rpc/google.cloud.bigquery.storage.v1#google.cloud.bigquery.storage.v1.ReadSession.TableReadOptions.FIELDS.string.google.cloud.bigquery.storage.v1.ReadSession.TableReadOptions.row_restriction For related work, see "filters" in pandas...

tswast

Rare Block on GBQ write:

5

#### Environment details - OS type and version: macOS, Ventura 13.5.2. - Python version: `python --version` 3.10.12 - pip version: `pip --version` pip 23.2.1 from /Users/awd/mambaforge/envs/AMPMatrixRecovery/lib/python3.10/site-packages/pip (python 3.10) - `pandas-gbq`...

adonoho

bug: shouldn't be trying blank project ID when no project ID is found

2

I get a `NotFound` error where pandas-gbq has tried to send a query with an empty string as the project ID. This could be improved to show a better error...

tswast

if on a remote server (e.g. using `auth_local_webserver=False`), then don't cache user credentials by default

1

If on a remote server (e.g. using `auth_local_webserver=False`), then there's a good chance the code is running on a shared machine (e.g. a VM or Colab notebook). In these cases,...

tswast

read_gbq results in lingering system thread after function call

1

Thanks for stopping by to let us know something could be better! **PLEASE READ**: If you have a support contract with Google, please create an issue in the [support console](https://cloud.google.com/support/)...

jlynchMicron

feat: Use nullable Float64Dtype to allow NULL and NaN to be represented in the same Series when `dtype_backend="numpy_nullable"`

1

The Float64Dtype more closely matches the BigQuery semantics. Ideally we'd allow folks to use this to avoid the slight data loss of mapping both NULL and NaN to NaN with...

tswast