My Kong x Cassandra journey has been an interesting one. I wanted to reach out to hopefully get some advice on Kong accessing restored data from the Cassandra snapshot. It appears I am successfully restoring the schema and data tables for Cassandra (completing ‘nodetool refresh KEYSPACE TABLE’) however, when I use Postman to access Kong API to view all services I’m getting an empty array even though I can see the populated/restored data in the table via CQLSH. I’m curious to know what required tables need to be restored at minimum to allow Kong to access the older data. I started restoring tables one by one starting with Services, Routes, Consumers etc. but still haven’t rekindled the link between Kong instance and backup data.
For additional validation I created a new service and ran another GET via postman and the new service returns in the array as well as populates in the same table with the restored data visible in CQLSH.