We would like to store 1 year of data in KTABLE. Is it recommended to store such volumes of data(~1TB) in KTABLE. I am not sure if KTABLE can be used as a normal database.
That is a somewhat philosophical question.
Is it recommended to store such volumes of data(~1TB) in KTABLE.
It will be for sure a high end deployment, but ksqlDB should be able to handle it, if you have enough scale out capacity. If it’s recommended? Not sure. It’s not discouraged per-se though.
I am not sure if KTABLE can be used as a normal database.
Again, not sure what you exactly mean. ksqlDB is for sure different to a relational database. So it really depends what you exactly want to do…