Configurable global default for refreshKey

[vprus]

Unless I specify refreshKey for a particular code, it defaults to 2 minutes for BQ and to 10 seconds for other databases. That is really wasteful in our case. We update analytics once a day, to hitting database after 10 seconds is not necessary, a refreshKey of 'every 1 hour' will be more useful. I can change it for each cube, but this is tedious and error-prone work.

I would like a way to specify default refreshKey in configuration. Either as constant, or maybe as function taking database kind/name/appId/whatever.

I considered manually editing all cubes, but this is fragile - I can miss a cube, or a colleague can add a cube in future without setting refreshKey

[paveltiunov]

Hey @vprus ! Have you considered introducing constant and importing it everywhere? https://cube.dev/docs/schema/advanced/export-import#top

[vprus]

@paveltiunov : That allows to me put the constant in one place, yes. However, it still means that somebody can write a new cube, and forget to import the constant. Or, in bright future, this cube might be coming from dbt, authored by an analysts, who does have idea about refreshKey. A way to override it at the level of server config would be more robust.

[github-actions]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.