Islam_hoti
New Contributor

Hey, @airbots 

The index status just mirrors the sync pipeline behind it, so "syncing" forever usually means that pipeline is stuck, not your job. Go to Jobs & Pipelines, find the system-managed pipeline named after your index, and check its event log the actual error is almost always there.

Two things I'd rule out first: make sure delta.enableChangeDataFeed is on for the source table, and check whether your job is doing an overwrite/replace rather than append or merge. Either one breaks the CDF chain and forces a full re-snapshot, which on a big table looks exactly like being stuck.

Also worth running describe() on the index and looking at detailed state instead of the top-level status it's a lot more specific.