Ultimate

X_ENTITY_VIEW_DRIFT

Means

a view entity's columns disagree with the view its migration created

Typical cause

entity({ view }) declares columns the view's query does not output, or the query outputs columns no entity column names — measured on the scratch replay of the migrations, so every read of a missing column would fail with 42703 at runtime

Fix

x verify --only drift --json # the cause names the view entity and both column lists: make columns name exactly the view's output, or change view.sql and x db gen

Listed under CLI and verify

This page as markdown