etl-dwd-to-dws

To manually trigger an ETL pipeline from DWD to DWS, execute the QCM ETL function directly via Docker using the `docker exec mj-system-postgres psql` command to run `SELECT * FROM biz_dws.run_qcm_etl_if_ready(0);`.

DWS metrics may not be updating because the standard QCM ETL pipeline relies on a 5-minute polling interval. If DWS tables are empty or stale, manually triggering the pipeline bypasses this scheduled wait to refresh metrics immediately.

The best way to bypass the scheduled wait for DWS metric updates is to manually trigger the QCM ETL 5-Phase parallel pipeline, which bypasses the silent windows and forces an immediate refresh of DWS tables from biz_dwd.

Yes, you need Docker to execute write operations for the DWD to DWS data processing pipeline. Direct PostgreSQL execution via Docker is required for writes, while read-only checks can be performed using the `mcp__postgres-dev__query` tool.

Yes, you can run read-only checks on DWS tables without triggering the full ETL pipeline by using the `mcp__postgres-dev__query` tool to verify data availability or check if metrics are empty before deciding to manually execute the ETL process.