bug: bigquery.connect() does not work

[copernican]

What happened?

1. Create and activate new uv venv
2. uv pip install 'ibis-framework[bigquery]'
3. Authenticate to BigQuery with gcloud

Then attempt

import ibis
con = ibis.bigquery.connect(project_id="my-project", dataset_id="my-dataset")

This does not work.

What version of ibis are you using?

11.0.0

What backend(s) are you using, if any?

BigQuery

Relevant log output

Traceback (most recent call last):
  File "/path/to/.venv/lib/python3.13/site-packages/sqlglot/expressions.py", line 2634, in to_py
    return int(self.this)
ValueError: invalid literal for int() with base 10: 'binary_double_nan'

Code of Conduct

• I agree to follow this project's Code of Conduct

[copernican]

This appears to be related to sqlglot 28.7.0. I downgraded to 28.6.0 and things are now working as expected.

[tfrancisl]

I can confirm that I see this exact error with sqlglot 28.7.0 for the pyspark backend, and downgrading to 28.6.0 resolved.

[tfrancisl]

Related: tobymao/sqlglot#6908

[tfrancisl]

Resolved by #11839