googleapis/python-bigquery

`table_constraints` has no setter?

roy-work opened this issue · 0 comments

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

  1. Attempt to create a table w/ a primary key or FK
  2. 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