0

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

Jason Salemme 3 months ago updated 3 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!