Create Indices on Common Data Model vocabulary tables.

This function creates primary keys and indices for the vocabulary tables in the CDM.

Usage

index_vocabulary_tables()

Details

This function requires a configured config.yaml file created using amstel::create_config(). It will use the connection configuration specified in the cdm section to create the indices for the tables of the Common Data Model. Since the concept will be used often during the ETL of the AmsterdamUMCdb tables, it helps when these (static) tables have already been indexed.

This function assumes amstel::create_cdm_tables() and amstel::load_vocabulary_tables() have been run successfully.