Feedback: Views Docs and MaterializedView Types

[tonytrill]

Love that Moose Stack gives the ability to define MaterializedViews in code.

Couple of questions:

• ~~Is there a way to generate regular views in code using Moose Stack or does it have to be a MaterializedView? There are some simple queries I would like to add as normal Views but cannot find a way to do this in the API Docs.~~
• It looks like there is a View class but it not documented on in the API reference on the website!
• Is there a way to specify the MaterializedView type? Clickhouse has two different types, incremental or refreshable. I have a use case where I need to set the refresh interval on a view. Refreshable View Docs

Thanks!

[callicles]

Hi @tonytrill

Thanks for the callout on the docs—will update!

On the Refreshable Materialized View, we have a PR, but we have not gotten it across the finish line. https://github.com/514-labs/moosestack/pull/2514

We can reprioritize so that you have it as soon as possible.

Can you share what you are trying to achieve?

[tonytrill]

I use a batch process that loads data using a refreshable view every 30 minutes. I can't necessarily get into more details other than that unfortunately. The current code is configured in clickhouse cloud but I am trying to slowly migrate things over to Moose code for a POC.

[okane16]

@tonytrill the documentation has just been updated to include details for defining a View: https://github.com/514-labs/moosestack/pull/2866

We will move on to adding Refreshable MV support, should be able to turn that around quickly