Which Snowflake object uses credits for maintenance?
Which Snowflake object uses credits for maintenance?
Materialized views in Snowflake use credits for maintenance because they require periodic automatic refreshes to stay current with the underlying data. This maintenance process involves computational resources, which consume credits. Regular tables, regular views, and cached query results do not incur ongoing maintenance costs as they do not require active monitoring and refreshing.
Answer C
The automatic maintenance of materialized views consumes credits. For more details, see Materialized Views Cost (in this topic).