PyAirbyte icon indicating copy to clipboard operation
PyAirbyte copied to clipboard

🐛 Bug: BigQuery `to_pandas()` and `read_sql_table()` don't work

Open aaronsteers opened this issue 1 year ago • 5 comments

Discovered when working on another PR:

  • #144

It appears to_pandas() fails when run against BigQuery.

sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(bigquery://dataline-integration-testing?credentials_path=%2Fvar%2Ffolders%2Fs2%2Fvn4r87x53fx8v_n79pxyvc_r0000gq%2FT%2Ftmpq6yf1owc) schema 'test_deleteme_c6wj0k': (users)

Repro condition documented in code here:

  • https://github.com/airbytehq/PyAirbyte/pull/144/commits/750b1a57f1156dc9dc6c0922ac1f45c06e16d42a

aaronsteers avatar Apr 03 '24 03:04 aaronsteers

Found the same issue in:

  • #281

Added read_sql_table() in issue title.

aaronsteers avatar Jul 09 '24 04:07 aaronsteers