backup restore job didnt update materialized views data about clickhouse-backup HOT 3 CLOSED

Restoring from backup this is not INSERT, this is ALTER TABLE ... ATTACH PART and it will not trigger materialized view

from clickhouse-backup.

do you have a suggestion on how can i use the data from restored tables like the materialized view?
one solution that came to my mind is creating cronjobs to move updated data to other tables but at a bigger scale, it may cause some difficulties.

from clickhouse-backup.

When you create backup you also create backup destination table for your materialized view
during restore you will restore state of MV destination table

(look to TO db.table clause in CREATE MATERIALIZED VIEW query , or .inner.{uuid} table if you created MV without TO clause)

I don't understand what you exactly trying to do, looks like you don't understand what is Materialized View and how it works

from clickhouse-backup.