PyAirbyte
PyAirbyte copied to clipboard
🐛 Bug: BigQuery `to_pandas()` and `read_sql_table()` don't work
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
Found the same issue in:
- #281
Added read_sql_table() in issue title.