OHDSI Home | Forums | Wiki | Github

Primary Keys (and constraints) in Databricks

It looks like Databricks does support primary keys and constraints in some cases but not in most. For example, I’m getting this error that indicates that constraints are not supported using Hive metastore.

UnsupportedOperationException: Add table constraint is not supported with Hive Metastore

Also, the DDL scripts from CommonDataModel are failing when I try to run them.

Are most implementers simply not implementing primary keys and other constraints when creating an OHDSI on Databricks implementation?

Is this already documented someplace?