Statically generate published / embed chart pages

[bprusinowski]

As (probably) most cubes aren't updated very often, we could statically generate published / embed pages to be loaded instantly (using Incremental Static Regeneration).

There would be a need to manually trigger revalidation (https://nextjs.org/docs/pages/building-your-application/data-fetching/incremental-static-regeneration#using-on-demand-revalidation) after a cube's been updated. We could have an API route that would retrieve all chart ids that are using that cube from the database, and purge the cache for them in such event.

Prerequisites

• [x] Investigate if Cube Creator supports web hooks on cube update

[sosiology]

• Discussed internally with Mark, but requires input/ alignment with zazuko and with the client.
• Assumed to be a bigger issue with a dependency to zazuko
• In a next step, Bartosz would like to discuss this with Patrick after which we will decide when to discuss it with the client.