`table_constraints` has no setter?
roy-work opened this issue · 0 comments
roy-work commented
AFAICT, it does not seem possible to create a table with the Python library, as table_constraints
is inexplicably unsettable. (You can't, AFAICT, create PK/FK constraints via the Console, either, so I am beginning to wonder how one does make use of this feature.)
Environment details
- OS type and version: macOS 14.5
- Python version:
python --version
:Python 3.12.3
- pip version:
pip --version
pip 24.0 from /usr/local/lib/python3.12/site-packages/pip (python 3.12)
google-cloud-bigquery
version:pip show google-cloud-bigquery
Name: google-cloud-bigquery Version: 3.25.0 Summary: Google BigQuery API client library Home-page: https://github.com/googleapis/python-bigquery Author: Google LLC Author-email: googleapis-packages@google.com License: Apache 2.0 Location: <snip> Requires: google-api-core, google-auth, google-cloud-core, google-resumable-media, packaging, python-dateutil, requests Required-by:
Steps to reproduce
- Attempt to create a table w/ a primary key or FK
- Run into trouble.
Code example
Where a_bq_table
is a Table
, and constraints
is a TableConstraints
In [72]: a_bq_table.table_constraints = constraints
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
Cell In[72], line 1
----> 1 a_bq_table.table_constraints = constraints
AttributeError: property 'table_constraints' of 'Table' object has no setter
Stack trace
N/A