Add new columns (create_query and source)

Why it matters

This feature enhances the system.named_collections table by providing more detailed metadata about named collections. The create_query column stores the original query used to create the collection, while the source column indicates the origin of the collection. This allows users to better understand and audit named collections, improving transparency and manageability.

How to use it

Query the system.named_collections table to retrieve the new columns as part of your regular inspection of named collections, for example:

SELECT collection_name, create_query, source
FROM system.named_collections
WHERE collection_name = 'your_collection_name'

No additional configuration or setup is required to use these columns.