OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
896 stars 453 forks source link

add sort key to redshift ddl #536

Open fdefalco opened 2 years ago

fdefalco commented 2 years ago

Is it possible to add sort key definitions to the ddl. Initial findings are that distkey of person_id and sort key of domain_concept_id (ie measurement_concept_id), person_id seem optimal.

clairblacketer commented 2 weeks ago

@fdefalco should we still look to do this? We have the distkeys but not the sortkeys.