googleapis / googleapis/google-cloud-python

read_gbq: Runtime error when given table name for a view

Abierto
#14,471 0 comentarios 0 reacciones 1 asignado Reclamado por @tswast Ver en GitHub
api: bigquery type: feature request
Lenguaje dominante
Python
Estrellas
5.4k
Forks
1.8k
Merge medio
3 d 4 h
PR fusionados (30 d)
122

Descripción

When I try to use `read_gbq` where I pass in the name of a view, I get a runtime error caused by an unhandled 400 error from the API.

It looks like `read_gbq` tries to use the `tabledata.list` method which is not supported by the BigQuery API for views. I would expect `read_gbq` to be able to handle this query and use an appropriate API method.

As a work around, I am able to run the query `SELECT * FROM my_dataset.my_table` instead.

#### Environment details

- OS type and version: macOS 15.3.1 on M4 Pro
- Python version: 3.13.2
- `pandas-gbq` version: 0.28.0
- `google-cloud-bigquery` version: 3.30.0

#### Code example

```python
import pandas_gbq as pd_gbq

pd_gbq.read_gbq("my_dataset.my_table")
```

where `my_table` is a VIEW

#### Error

```
GenericGBQException: Reason: 400 GET : Cannot list a table of type VIEW.
```

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.