- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2026 07:32 AM
Is there any documentation available around the changeset size thresholds for materialized view incremental refreshes? Are these configurable at all? Are they constant or do the thresholds change depending on the number of rows/size of the materialized view?
We frequently see MVs perform full refreshes with the cost_model_rejection_subtype being "CHANGESET_SIZE_THRESHOLD_EXCEEDED". These MVs are already running every ~15 minutes so they can't be run more frequently without moving them to a streaming/continuous model, and the changeset sizes are modest relative to total data size. Curious if there would be a way to increase that threshold and not have to the force the MV into an incremental refresh using a refresh policy, or just generally if there is more information available around what the threshold is/how it's determined.