Freshly downloaded bigframes got error AttributeError: type object 'Type' has no attribute 'UNIQUEIDENTIFIER'

[hellowin]

Environment details

• OS type and version: Ubuntu 24.04.1 LTS
• Python version: 3.12.8
• pip version: 24.3.1
• bigframes version: 1.35.0

Python: 3.12.8 (main, Jan 11 2025, 16:32:40) [GCC 13.3.0]
google-cloud-bigquery==3.29.0
pandas==2.2.3
pyarrow==19.0.0
sqlglot==26.6.0

Steps to reproduce

1. Just install bigframes, I tried using 1.34.0 and 1.35.0
2. When doing import bigframes it raised an error
3. I noticed this error raised just recently, around Feb 10th 2025, 8PM UTC

Code example

import bigframes

Stack trace

AttributeError                            Traceback (most recent call last)
Cell In[8], [line 2](vscode-notebook-cell:?execution_count=8&line=2)
      [1](vscode-notebook-cell:?execution_count=8&line=1) import sys
----> [2](vscode-notebook-cell:?execution_count=8&line=2) import bigframes
      [3](vscode-notebook-cell:?execution_count=8&line=3) import google.cloud.bigquery
      [4](vscode-notebook-cell:?execution_count=8&line=4) import pandas

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/__init__.py:19
     [17](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/__init__.py:17) from bigframes._config import option_context, options
     [18](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/__init__.py:18) from bigframes._config.bigquery_options import BigQueryOptions
---> [19](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/__init__.py:19) from bigframes.core.global_session import close_session, get_global_session
     [20](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/__init__.py:20) import bigframes.enums as enums
     [21](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/__init__.py:21) import bigframes.exceptions as exceptions

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/core/global_session.py:26
     [24](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/core/global_session.py:24) import bigframes._config
     [25](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/core/global_session.py:25) import bigframes.exceptions as bfe
---> [26](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/core/global_session.py:26) import bigframes.session
     [28](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/core/global_session.py:28) _global_session: Optional[bigframes.session.Session] = None
     [29](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/core/global_session.py:29) _global_session_lock = threading.Lock()

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/session/__init__.py:40
     [37](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/session/__init__.py:37) import weakref
     [39](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/session/__init__.py:39) import bigframes_vendored.constants as constants
---> [40](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/session/__init__.py:40) import bigframes_vendored.ibis.backends.bigquery as ibis_bigquery  # noqa
     [41](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/session/__init__.py:41) import bigframes_vendored.pandas.io.gbq as third_party_pandas_gbq
     [42](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes/session/__init__.py:42) import bigframes_vendored.pandas.io.parquet as third_party_pandas_parquet

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:28
     [24](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:24) from bigframes_vendored.ibis.backends.bigquery.udf.core import (
     [25](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:25)     PythonToJavaScriptTranslator,
     [26](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:26) )
     [27](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:27) from bigframes_vendored.ibis.backends.sql import SQLBackend
---> [28](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:28) from bigframes_vendored.ibis.backends.sql.compilers import BigQueryCompiler
     [29](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:29) from bigframes_vendored.ibis.backends.sql.datatypes import BigQueryType
     [30](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/bigquery/__init__.py:30) import bigframes_vendored.ibis.common.exceptions as com

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/__init__.py:9
      [3](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/__init__.py:3) from __future__ import annotations
      [5](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/__init__.py:5) __all__ = [
      [6](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/__init__.py:6)     "BigQueryCompiler",
      [7](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/__init__.py:7) ]
----> [9](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/__init__.py:9) from bigframes_vendored.ibis.backends.sql.compilers.bigquery import BigQueryCompiler

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:19
     [12](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:12) import bigframes_vendored.ibis.backends.bigquery.datatypes as bq_datatypes
     [13](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:13) from bigframes_vendored.ibis.backends.sql.compilers.base import (
     [14](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:14)     AggGen,
     [15](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:15)     NULL,
     [16](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:16)     SQLGlotCompiler,
     [17](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:17)     STAR,
     [18](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:18) )
---> [19](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:19) from bigframes_vendored.ibis.backends.sql.datatypes import BigQueryType, BigQueryUDFType
     [20](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:20) from bigframes_vendored.ibis.backends.sql.rewrites import (
     [21](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:21)     exclude_unsupported_window_frame_from_ops,
     [22](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:22)     exclude_unsupported_window_frame_from_rank,
     [23](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:23)     exclude_unsupported_window_frame_from_row_number,
     [24](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:24) )
     [25](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/compilers/bigquery/__init__.py:25) import bigframes_vendored.ibis.common.exceptions as ibis_exceptions

File ~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:66
     [12](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:12) import sqlglot.expressions as sge
     [14](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:14) typecode = sge.DataType.Type
     [16](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:16) _from_sqlglot_types = {
     [17](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:17)     typecode.BIGDECIMAL: partial(dt.Decimal, 76, 38),
     [18](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:18)     typecode.BIGINT: dt.Int64,
     [19](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:19)     typecode.BINARY: dt.Binary,
     [20](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:20)     typecode.BOOLEAN: dt.Boolean,
     [21](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:21)     typecode.CHAR: dt.String,
     [22](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:22)     typecode.DATE: dt.Date,
     [23](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:23)     typecode.DATE32: dt.Date,
     [24](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:24)     typecode.DOUBLE: dt.Float64,
     [25](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:25)     typecode.ENUM: dt.String,
     [26](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:26)     typecode.ENUM8: dt.String,
     [27](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:27)     typecode.ENUM16: dt.String,
     [28](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:28)     typecode.FLOAT: dt.Float32,
     [29](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:29)     typecode.FIXEDSTRING: dt.String,
     [30](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:30)     typecode.HSTORE: partial(dt.Map, dt.string, dt.string),
     [31](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:31)     typecode.INET: dt.INET,
     [32](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:32)     typecode.INT128: partial(dt.Decimal, 38, 0),
     [33](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:33)     typecode.INT256: partial(dt.Decimal, 76, 0),
     [34](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:34)     typecode.INT: dt.Int32,
     [35](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:35)     typecode.IPADDRESS: dt.INET,
     [36](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:36)     typecode.JSON: dt.JSON,
     [37](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:37)     typecode.JSONB: partial(dt.JSON, binary=True),
     [38](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:38)     typecode.LONGBLOB: dt.Binary,
     [39](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:39)     typecode.LONGTEXT: dt.String,
     [40](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:40)     typecode.MEDIUMBLOB: dt.Binary,
     [41](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:41)     typecode.MEDIUMTEXT: dt.String,
     [42](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:42)     typecode.MONEY: dt.Decimal(19, 4),
     [43](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:43)     typecode.NCHAR: dt.String,
     [44](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:44)     typecode.UUID: dt.UUID,
     [45](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:45)     typecode.NAME: dt.String,
     [46](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:46)     typecode.NULL: dt.Null,
     [47](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:47)     typecode.NVARCHAR: dt.String,
     [48](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:48)     typecode.OBJECT: partial(dt.Map, dt.string, dt.json),
     [49](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:49)     typecode.ROWVERSION: partial(dt.Binary, nullable=False),
     [50](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:50)     typecode.SMALLINT: dt.Int16,
     [51](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:51)     typecode.SMALLMONEY: dt.Decimal(10, 4),
     [52](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:52)     typecode.TEXT: dt.String,
     [53](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:53)     typecode.TIME: dt.Time,
     [54](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:54)     typecode.TIMETZ: dt.Time,
     [55](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:55)     typecode.TINYBLOB: dt.Binary,
     [56](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:56)     typecode.TINYINT: dt.Int8,
     [57](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:57)     typecode.TINYTEXT: dt.String,
     [58](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:58)     typecode.UBIGINT: dt.UInt64,
     [59](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:59)     typecode.UINT: dt.UInt32,
     [60](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:60)     typecode.USMALLINT: dt.UInt16,
     [61](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:61)     typecode.UTINYINT: dt.UInt8,
     [62](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:62)     typecode.UUID: dt.UUID,
     [63](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:63)     typecode.VARBINARY: dt.Binary,
     [64](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:64)     typecode.VARCHAR: dt.String,
     [65](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:65)     typecode.VARIANT: dt.JSON,
---> [66](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:66)     typecode.UNIQUEIDENTIFIER: dt.UUID,
     [67](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:67)     typecode.SET: partial(dt.Array, dt.string),
     [68](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:68)     #############################
     [69](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:69)     # Unsupported sqlglot types #
     [70](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:70)     #############################
     [71](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:71)     # BIT = auto() # mysql
     [72](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:72)     # BIGSERIAL = auto()
     [73](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:73)     # DATETIME64 = auto() # clickhouse
     [74](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:74)     # ENUM = auto()
     [75](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:75)     # INT4RANGE = auto()
     [76](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:76)     # INT4MULTIRANGE = auto()
     [77](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:77)     # INT8RANGE = auto()
     [78](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:78)     # INT8MULTIRANGE = auto()
     [79](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:79)     # NUMRANGE = auto()
     [80](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:80)     # NUMMULTIRANGE = auto()
     [81](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:81)     # TSRANGE = auto()
     [82](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:82)     # TSMULTIRANGE = auto()
     [83](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:83)     # TSTZRANGE = auto()
     [84](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:84)     # TSTZMULTIRANGE = auto()
     [85](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:85)     # DATERANGE = auto()
     [86](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:86)     # DATEMULTIRANGE = auto()
     [87](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:87)     # HLLSKETCH = auto()
     [88](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:88)     # IMAGE = auto()
     [89](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:89)     # IPPREFIX = auto()
     [90](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:90)     # SERIAL = auto()
     [91](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:91)     # SET = auto()
     [92](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:92)     # SMALLSERIAL = auto()
     [93](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:93)     # SUPER = auto()
     [94](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:94)     # TIMESTAMPLTZ = auto()
     [95](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:95)     # UNKNOWN = auto()  # Sentinel value, useful for type annotation
     [96](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:96)     # UINT128 = auto()
     [97](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:97)     # UINT256 = auto()
     [98](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:98)     # USERDEFINED = "USER-DEFINED"
     [99](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:99)     # XML = auto()
    [100](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:100) }
    [102](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:102) _to_sqlglot_types = {
    [103](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:103)     dt.Null: typecode.NULL,
    [104](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:104)     dt.Boolean: typecode.BOOLEAN,
   (...)
    [122](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:122)     dt.Time: typecode.TIME,
    [123](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:123) }
    [125](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:125) _geotypes = {
    [126](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:126)     "POINT": dt.Point,
    [127](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:127)     "LINESTRING": dt.LineString,
   (...)
    [131](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:131)     "MULTIPOLYGON": dt.MultiPolygon,
    [132](https://vscode-remote+wsl-002bubuntu-002d24-002e04.vscode-resource.vscode-cdn.net/home/hellowin/workspace/gercep/pipeline/notebook/~/workspace/gercep/pipeline/.venv/lib/python3.12/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py:132) }

AttributeError: type object 'Type' has no attribute 'UNIQUEIDENTIFIER'

[hellowin]

Relevant PR #1379

[Genesis929]

Hi hellowin:

Thanks for the feedback. We apologize for the issue you're experiencing with bigframes.

We're working on a fix and will release it soon. In the meantime, you can try the following workaround: pip install sqlglot==26.3.9.

This has been tested locally and works fine. We'll let you know as soon as the new version with the fix is available.

[hellowin]

@Genesis929 it solved by this PR #1360
Thanks team 🙏

[shobsi]

I can repro the issue with bigframes version 1.35.0.

$ python -m venv venv1
$ source venv1/bin/activate
$ pip freeze
$ pip install bigframes==1.35.0
...
$ pip freeze | grep -E "bigframes|sqlglot"
bigframes==1.35.0
sqlglot==26.6.0
$ python -c "import bigframes"
Traceback (most recent call last):
...
  File "/usr/local/google/home/shobs/code/bigframes/venv1/lib/python3.10/site-packages/bigframes_vendored/ibis/backends/sql/datatypes.py", line 66, in <module>
    typecode.UNIQUEIDENTIFIER: dt.UUID,
  File "/usr/local/google/home/shobs/.pyenv/versions/3.10.12/lib/python3.10/enum.py", line 437, in __getattr__
    raise AttributeError(name) from None
AttributeError: UNIQUEIDENTIFIER

It is because BigFrames does not use an upper bound package version for the sqlglot dependency (like most other dependencies). It was there earlier, but we removed it in #1278. Maybe we should always use an upper bound for every dependency?

Pinning the upper bounds statically is generally considered not a best practice, as it prevents the latest bug fixes and security patches in the dependencies from being delivered automatically at the time of install, and requires manual updates. However, for the sake of stability it may be useful to dynamically pin the latest version of every dependency that is available at the time of, and tested with, the BigFrames release.