Using Time to Live (TTL) with primary (partition) key columns

ScyllaDB
4

You can only use the TTL() function on non-primary key columns. So there’s no easy way to do this as of now.

You could try using mutation fragments:

select * from MUTATION_FRAGMENTS(test.table);

But this is more for diagnostics and not for reading the TTL value.