RDC ETL Definitions

SQL String Function Definitions

• stage_job_def_sql_string(TargetCatalogName)
  • returns sql string to list the functions that are enabled in the stage_rules table
• stage_omop_job_def_sql_string(TargetCatalogName, TargetOMOPEnv)
  • returns Env specific sql string to list the functions that are enabled in the stage_rules table
• omop_job_def_sql_string(TargetCatalogName)
  • returns sql string to list enabled delta rules from the stage_rules table
• etl_status_sql_string(department_name, TargetCatalogName)
  • returns sql string to get status from the config_main table
• etl_complete_sql_string(department_name, TargetCatalogName)
  • returns sql string to update the config_main table to set currently_running to false
• insert_history_sql_string(department_name, TargetCatalogName)
  • returns sql to insert task information into the history_main table

Get Parameters

• get_target_catalog_name_sql_string(department_name)
  • gets the database for this ETL (sandbox, dev, qa, prod)
• get_target_omop_env_sql_string(TargetOMOPEnv)
  • gets the OMOP environment for this ETL run (omop_dev, omop_qa, omop_prod)
• populate_information_tables(TargetCatalogName)
  • returns sql string to create the information_schema_tables from information_schema.tables
• truncate_stage_tables(TargetCatalogName, currentTimestamp, batch_job_id)