New Dependency Columns Added to system.tables Table

Why it matters

This feature helps users identify dependencies between tables directly from the system metadata, improving the ability to track and manage table relationships and their dependencies in ClickHouse.

How to use it

Query the system.tables table to access the new dependencies_database and dependencies_table columns alongside existing metadata, for example:

SELECT database, name, dependencies_database, dependencies_table
FROM system.tables
WHERE dependencies_table IS NOT NULL

This allows users to see which tables depend on others within their ClickHouse environment.