Tim Sweña (Swast)

Hi @jlynchMicron the feature to read directly from a table was added in pandas-gbq version 0.17.0 and later. https://github.com/googleapis/python-bigquery-pandas/blob/main/CHANGELOG.md#0170-2022-01-19 That may explain why you are encountering this error.

It's not possible to manually create a temporary table, but you can emulate one by creating a table with a default expiration time. > If this was possible, do you...

Yes, this is much easier to implement now that the BigQuery client has an [insert_rows_from_dataframe](https://googleapis.dev/python/bigquery/latest/generated/google.cloud.bigquery.client.Client.html#google.cloud.bigquery.client.Client.insert_rows_from_dataframe) method. Perhaps, a `use_streaming_api` parameter that defaults to `False`? Or if we want to support...

Now that we have some Geometry support in the `google-cloud-bigquery` library, I think this is a reasonable request. We may just need to pass `geometry_as_object=True` if available (necessary library versions...

I played a little around with this in BigFrames. I've had success getting SQLGlot to generate this syntax by passing args like this: ```python def visit_GeoRegionStats(self, op, *, arg, raster_id,...

Local tests pass with pandas 3.0.0rc0. ``` (venv) ➜ python-bigquery-pandas git:(tswast-pandas-3) ✗ pytest tests/ ============================================================================================================== test session starts ============================================================================================================== platform linux -- Python 3.13.5, pytest-9.0.1, pluggy-1.6.0 rootdir: /home/swast/src/github.com/googleapis/python-bigquery-pandas collected 339...

See: https://github.com/samhocevar/wincompose/issues/543 for some discussion on alternatives, such as the fork at https://github.com/ell1010/wincompose .

@chelsea-lin is working on a JSON dtype for https://github.com/googleapis/python-db-dtypes-pandas which is blocking this for `read_gbq` support. Otherwise, we'd end up returning strings (see: https://github.com/googleapis/python-bigquery/pull/1876#issuecomment-2025562693). Regarding loads via `to_gbq`, I believe...

I'm open to a pull request that adds this. Ideally, I'd like to see `to_gbq` gain a `configuration` parameter that takes a load job JSON configuration. ([job configuration resource](https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfiguration), [load...

> Why does the expirationMs need to be passed as a string though? It's a historical artifact of the BigQuery REST endpoint using an older JSON parsing implementation that only...