Skip to main content

Create cdw config DuckDB database file used for validation (Optional)

The alp-minerva-cdw-svc uses a DuckDB database file for validation purposes. This file comes with the source code at services/cdw-svc/src/duckdb/cdw_config_svc_validation_schema.

However, in the case of further updates to any data models, an updated validation DuckDB database file is required. In order to create this updated validation DuckDB database file, run the following steps.

Prerequisite: create_cachedb_file_plugin job is available in the Job Portal

Creating via portal​

  • open https://localhost:443/portal

  • Login as primary admin and change to Admin Portal

  • Go to Jobs JobsPlugin

  • Click the Jobs tab. JobsTab

  • Click the ⋮ icon, and select Quick Run. DeploymentQuickRun

  • Click the JSON tab and enter values to create a cdw-config validation DuckDB database file for cdmdefault

    namevaluenote
    Flow parameters{ "options": { "schemaName": "cdmdefault", "databaseCode": "alpdev_pg", "createForCdwConfigValidation": true } }Create cdw-config validation DuckDB database file for cdmdefault schema

    Example:

    CachedbCdwConfigFlowRunJSONDialog