Event Dime

Using native incremental materialized view for model persistence instead for database that support it

Community & CultureParades & CivicsCommunity & Culture / Parades & Civics
AI signals
CasualGeneral PublicIndigenous/NativePublic
When:
July 27, 2026 · 7:50 AM
Where:
Metabase
Source:
Metabase Discussion

I’ve only hit one problem in Postgres. Not sure if it only affects Postgres or not. In a MV, you can’t define a column as nullable or not. That means that when you have a filter that excludes (<>), Metabase puts in a or is null which prevents an index being used efficiently. That said, you still get much better control than you do with materialising a model in Metabase and at least you can have some indexes.

Indigenous/NativeCasualGeneral PublicPublic

Why this event appears here

This listing is shown because it is tied to the current city coverage and carries structured metadata that can be indexed and compared with other events.

  • City coverage

    Chicago, IL

  • Primary source

    Metabase Discussion

  • Categories

    Community & Culture, Parades & Civics, Community & Culture / Parades & Civics

  • Signals

    Indigenous/Native, Casual, General Public, Public