GitHub user dosubot[bot] added a comment to the discussion: Cache warm_up logic?
<!-- Answer --> Superset doesn't provide a built-in way to export or enumerate all the chart data payloads (like those sent to /api/v1/chart/data) for every dashboard. To automate cache warmup for all dashboards, you would need to write a custom script that: 1. Uses the Superset API to list all dashboards and their charts. 2. For each chart, fetches its configuration and constructs the correct payload (including filters, columns, metrics, etc.) for /api/v1/chart/data. 3. Sends a POST request to /api/v1/chart/data (or /api/v1/chart/warm_up_cache) with that payload to warm up the cache. There is no API to directly export the exact query context or payload as seen in the UI; you have to reconstruct it programmatically based on chart metadata and dashboard filter state. This is why cache warmup can feel "useless" out of the box for complex dashboardsâunless you replicate the real dashboard context (including filters and parameters), the cache key won't match what users actually request, so cache hits won't occur as expected. More details and examples are discussed here: [discussion 34750](https://github.com/apache/superset/discussions/34750), [discussion 34668](https://github.com/apache/superset/discussions/34668). In summary: bulk cache warmup is possible, but only with custom automation that mimics real dashboard/chart requests. Superset doesn't have a built-in feature for this. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=hallucination) | [Report đ](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/c7d96a57-ad68-4a53-9e42-d36fde059139?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/34837) GitHub link: https://github.com/apache/superset/discussions/34837#discussioncomment-14374924 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
