How to recover data from a snapshot file?

ScyllaDB
1

In some cases, I accidentally deleted a table in ScyllaDB. Now, how can I read the snapshot file from the snapshots directory in the ScyllaDB data directory to recover the data?
The directory for snapshot files is as follows:

[deployer@localhost 1689328944892-bl_stats]$ pwd
/var/lib/indexer/data/alternator_bl_stats/bl_stats-0f5c41c0eb0d11eda9adb2259d2c7158/snapshots/1689328944892-bl_stats
[deployer@localhost 1689328944892-bl_stats]$ ll
total 111
-rw-r--r-- 1 root root   174 Jul 14 18:02 manifest.json
-rw-r--r-- 1 root root    98 Jul 12 21:15 me-1327-big-CompressionInfo.db
-rw-r--r-- 1 root root 10189 Jul 12 21:15 me-1327-big-Data.db
-rw-r--r-- 1 root root    10 Jul 12 21:15 me-1327-big-Digest.crc32
-rw-r--r-- 1 root root   336 Jul 12 21:15 me-1327-big-Filter.db
-rw-r--r-- 1 root root     9 Jul 12 21:15 me-1327-big-Index.db
-rw-r--r-- 1 root root   302 Jul 12 21:15 me-1327-big-Scylla.db
-rw-r--r-- 1 root root  4932 Jul 12 21:15 me-1327-big-Statistics.db
-rw-r--r-- 1 root root    59 Jul 12 21:15 me-1327-big-Summary.db
-rw-r--r-- 1 root root   102 Jul 12 21:15 me-1327-big-TOC.txt
-rw-r--r-- 1 root root    98 Jul 14 18:02 me-1407-big-CompressionInfo.db
-rw-r--r-- 1 root root 10091 Jul 14 18:02 me-1407-big-Data.db
-rw-r--r-- 1 root root    10 Jul 14 18:02 me-1407-big-Digest.crc32
-rw-r--r-- 1 root root    16 Jul 14 18:02 me-1407-big-Filter.db
-rw-r--r-- 1 root root     9 Jul 14 18:02 me-1407-big-Index.db
-rw-r--r-- 1 root root   300 Jul 14 18:02 me-1407-big-Scylla.db
-rw-r--r-- 1 root root  4944 Jul 14 18:02 me-1407-big-Statistics.db
-rw-r--r-- 1 root root    59 Jul 14 18:02 me-1407-big-Summary.db
-rw-r--r-- 1 root root   102 Jul 14 18:02 me-1407-big-TOC.txt
-rw-r--r-- 1 root root    66 Jul 12 21:14 me-568-big-CompressionInfo.db
-rw-r--r-- 1 root root   116 Jul 12 21:14 me-568-big-Data.db
-rw-r--r-- 1 root root    10 Jul 12 21:14 me-568-big-Digest.crc32
-rw-r--r-- 1 root root    16 Jul 12 21:14 me-568-big-Filter.db
-rw-r--r-- 1 root root     9 Jul 12 21:14 me-568-big-Index.db
-rw-r--r-- 1 root root   300 Jul 12 21:14 me-568-big-Scylla.db
-rw-r--r-- 1 root root  4949 Jul 12 21:14 me-568-big-Statistics.db
-rw-r--r-- 1 root root    59 Jul 12 21:14 me-568-big-Summary.db
2

To recover the data from a snapshot, copy all the sstables from the snapshot, to the upload directory in the table’s data directory, then issue nodetool refresh. If the topology has changed since the snapshot was created, you should use nodetool refresh --load-and-stream.
Make sure to not copy auxiliary files, like manifest.json and schema.cql.