v.20.3New Feature

Added last_successful_update_time column to system.dictionaries table

Added last_successful_update_time column in system.dictionaries table #9394 (Nikita Mikhaylov)
Added a new column last_successful_update_time to the system.dictionaries table.

Why it matters

This feature provides users with the ability to monitor the last successful update timestamp of dictionaries directly from the system.dictionaries table, improving observability and aiding in troubleshooting dictionary synchronization issues.

How to use it

Users can query the system.dictionaries table and inspect the last_successful_update_time column to see when each dictionary was last successfully updated, for example:

SELECT name, last_successful_update_time FROM system.dictionaries;