googleapis / googleapis/google-cloud-python

read_gbq: Runtime error when given table name for a view

未关闭
#14,471 0 条评论 0 个 reaction 已指派 1 人 已被 @tswast 认领 在 GitHub 查看
api: bigquery type: feature request
主要语言
Python
星标
5.4k
派生
1.8k
平均合并
3 天 4 小时
30 天内合并 PR
122

描述

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.
```

贡献指南

打开贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。