0

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

Jason Salemme 10 months ago updated 10 months ago 1

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

OK... so now they are magically showing up.  Nevermind!