How to add `refresh rate` in config for materialized views in dataform ?

[Rstar1998]

Also in addition to this , is there any precise documentation where we can lookup what all key values we can put in config for tables , view etc

[astorrs]

We had discussed having that when support for materialized views was first added (https://github.com/dataform-co/dataform/pull/1302) but I'm not sure if it was ever implemented. @BenBirt ?

[BenBirt]

No, we haven't added that yet unfortunately.

Probably the best place to see what options are available is: https://docs.dataform.co/reference#ITableConfig

[Ekrekr]

Otherwise known as refresh frequency https://cloud.google.com/bigquery/docs/materialized-views-create#manage_staleness_and_refresh_frequency

[canberkkoparal]

It is possible to achieve this using using bigquery.additionalOptions since #1335 example config:

config { 
    type: "view",
    materialized: true,
    bigquery: {
        additionalOptions: {
            enable_refresh: "true",
            refresh_interval_minutes: "30"
        }
    }
}

would produce sql with OPTIONS(enable_refresh=true, refresh_interval_minutes=30) One important thing is these are not type/validty checked in anyway, so you would not get any errors until execution (i.e. it would compile) Here's our documentation and available options for materialized views