dsp-multi-asset-importer

To backfill historical DSP Multi Asset holdings into ClickHouse, run the import_dsp_history.py script, which automates the 31-month historical data population and validation for the market_data.mf_holdings table. It handles fund_code DSP_MULTI_ASSET coverage from Sep 2023 through Mar 2026.

Validating month coverage for DSP fund holdings in ClickHouse is handled by built-in validation checks within the backfill script. These checks identify missing or inconsistent months in the market_data.mf_holdings table to ensure complete historical data integrity for the DSP_MULTI_ASSET fund.

Yes, you can re-import specific months of DSP holdings data without a full overwrite. The script supports targeted re-import workflows and dry-run validation, allowing you to verify data for individual months before performing write operations to the ClickHouse database.

Yes, importing DSP history into market_data.mf_holdings requires read and write access to a ClickHouse database. You also need the import_dsp_history.py script to execute the backfill, re-import, and verification workflows for the fund allocations.

Auditing asset allocations and top holdings for the DSP Multi Asset fund is done using quick audit queries provided by the skill. These queries inspect the latest holdings data in ClickHouse to review the asset mix and verify the fund's current allocation distribution.