v.25.6Improvement

Add _time virtual column in S3Queue, AzureQueue

Add _time virtual column in S3Queue, AzureQueue engine. #78926 (Anton Ivashkin).
Added a _time virtual column to the S3Queue and AzureQueue table engines in ClickHouse.

Why it matters

This feature provides the ability to access the event ingestion time as a virtual column, enabling users to track or filter data based on the time when messages were processed from S3 or Azure queues. It enhances data timeliness analysis and troubleshooting capabilities.

How to use it

Users can query the _time virtual column directly in their SQL statements from tables using the S3Queue or AzureQueue engines, for example:

SELECT _time, <other_columns> FROM <table_name> WHERE <conditions>

No additional configuration is required to enable this column.