Question

You manage an Eventhouse (KQL database) that ingests IoT telemetry through a data connection. Overnight, downstream dashboards show no new rows for one table, while other tables continue to update normally. You need to quickly determine whether ingestion for that specific table is failing and see the underlying error messages. Which action should you take first?

Accepted Answer

Run the .show ingestion failures command against the affected table to review recent failed ingestion operations and their error reasons

Answer

Increase the hot cache retention period on the affected table to force the ingested data to reappear in queries

Answer

Drop and recreate the table so that the ingestion pipeline starts writing fresh data

Answer

Create a materialized view over the table to deduplicate the missing records