google-cloud-python

google-cloud-python copied to clipboard

Running a parameterized query via a SQLAlchemy Selectable

4

**Is your feature request related to a problem? Please describe.** I'm back again, after submitting googleapis/python-bigquery-pandas#474 and googleapis/python-bigquery-pandas#476, as we're trying to shift from using pd.read_sql_query to using pandas_gbq.read_gbq ....

rjrudin

Better support for parameterized queries

2

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/)...

brunokim

Hi, after checking out the `pandas_gbq.read_gbq` call parametrization I see that I can supply `configuration={'dry_run': True}` to make the query job to be a dry run. However it will still...

ehborisov

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

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

`dtypes_backend` options: * `"default"` (current "mixed" behavior, where most extension dtypes are used but not Float64Dtype or StringDtype) -- edit: might want to check `dtype_backend` in pandas global options (per...

tswast

**Is your feature request related to a problem? Please describe.** I'd like to be able to control when the DataFrame Index/MultiIndex is included in the serialized BigQuery table. **Describe the...

tswast

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

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

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