CommonDataModel
CommonDataModel copied to clipboard
add sort key to redshift ddl
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.
@fdefalco should we still look to do this? We have the distkeys but not the sortkeys.