0
Answered

BigQuery physical model does not allow me to set the primary key for a table

Jason Salemme 2 year бұрын updated by Łukasz Kubicki 4 апта бұрын 2

Is there a way to enable the primary key selection for tables when the physical model is for BigQuery?  While PKs and FKs are not enforced by BQ, they are used by the optimizer when resolving queries.  If there is no way to turn this on, can this feature be added please?

Thanks,
Jason