v.25.11New Feature

Add new virtual column _tags

Add new virtual column _tags (Map(String, String)) with all the tags associated with the blob in S3 (Note, if blob does not have any tags no extra request will be done). Resolves #72945. #77773 (Zicong Qu).
Introduces a new virtual column _tags of type Map(String, String) that exposes all tags associated with blobs stored in S3 within ClickHouse tables.

Why it matters

This feature provides users with easy and direct access to blob tags in S3 without requiring additional explicit requests or queries. It improves metadata visibility for objects in S3, enabling more efficient filtering, auditing, or management of blobs based on their tags. If the blob has no tags, no extra request is made, optimizing performance.

How to use it

Users can simply include the virtual column _tags in their SELECT queries on tables using the S3 storage engine to retrieve associated blob tags. For example:

SELECT _tags FROM <table_name> WHERE ...

No additional configuration is needed; the column is available automatically.