Using Starburst Cache service with dbt

Starburst Galaxy
,
1

Is anyone aware of any ways where we can use the Starburst Cache service with dbt?
For instance If I want a model (table in this case) to refresh periodically using either a cron schedule or a constant 24 hour refresh, How can I embed that in my dbt model?

2

Using dbt for query orchestration, found that this code works via properties you can pass WITH clause properties of MV like cron or refresh_interval etc

{{
   config(
       materialized = 'materialized_view',
       properties= {
           "cron" : "'30 2 * * *'",
       }
   )
 }}
3

You can also directly have these properties defined in your CREATE MATERIALIZED VIEW statement in the WITH clause. And if the MV already exists you can use ALTER MATERIALIZED VIEW (see ALTER MATERIALIZED VIEW — Starburst Galaxy SQL reference)