# Metadata columns from a topic in ksqldb stream/table

**URL:** <https://forum.confluent.io/t/metadata-columns-from-a-topic-in-ksqldb-stream-table/2895>\
**Category:** ksqlDB\
**Created:** [27 September 2021 10:57 UTC](https://forum.confluent.io/t/metadata-columns-from-a-topic-in-ksqldb-stream-table/2895 "2021-09-27T10:57:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bk003](https://avatars.discourse-cdn.com/v4/letter/b/7cd45c/32.png) [@bk003](https://forum.confluent.io/u/bk003)\
**Post date:** [27 September 2021 10:57 UTC](https://forum.confluent.io/t/metadata-columns-from-a-topic-in-ksqldb-stream-table/2895/1 "2021-09-27T10:57:48Z")

</div>

Hi All,

Is it possible to get the metadata values of topic name, partition, offset and timestamp from an underlying topic of a ksql stream?

Thank you!

---

<div class="post-metadata">

**Author:** ![mjsax](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/mjsax/32/3113_2.png) [@mjsax](https://forum.confluent.io/u/mjsax)\
**Post date:** [27 September 2021 16:09 UTC](https://forum.confluent.io/t/metadata-columns-from-a-topic-in-ksqldb-stream-table/2895/2 "2021-09-27T16:09:50Z")

</div>

You can access the timestamp via the `ROWTIME` (pseudo/system) column, that is present for every STREAM or TABLE.

Topic name, partition, and offset are not exposed atm, but it’s already WIP. The goal is to release this new feature with ksqlDB 0.23 or 0.24: [ksql/klip-50-partition-and-offset-in-ksqldb.md at c09c362294c8a51c6484e4a3ee995d25bbf487d1 · confluentinc/ksql · GitHub](https://github.com/confluentinc/ksql/blob/c09c362294c8a51c6484e4a3ee995d25bbf487d1/design-proposals/klip-50-partition-and-offset-in-ksqldb.md)

---

<div class="post-metadata">

**Author:** ![bk003](https://avatars.discourse-cdn.com/v4/letter/b/7cd45c/32.png) [@bk003](https://forum.confluent.io/u/bk003)\
**Post date:** [27 September 2021 16:43 UTC](https://forum.confluent.io/t/metadata-columns-from-a-topic-in-ksqldb-stream-table/2895/3 "2021-09-27T16:43:17Z")

</div>

Thanks for the information!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [4 October 2021 16:44 UTC](https://forum.confluent.io/t/metadata-columns-from-a-topic-in-ksqldb-stream-table/2895/4 "2021-10-04T16:44:13Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.