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

For alp-minerva-cdw-svc, it 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.

Prerequisties: create_cachedb_file_plugin job is available in the Job Portal

• D2E-Plugins/flows/base/duckdb

Creating via portal

• open https://localhost:443/portal

• Login as primary admin

• Select Admin mode

• Navigate to Jobs

• Click on Jobs tab.

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

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

  name	value	note
  Flow parameters	{ "options": { "schemaName": "cdmdefault", "databaseCode": "alpdev_pg", "createForCdwConfigValidation": true } }	Create cdw-config validation duckdb database file for cdmdefault schema

  Example: