Hi Anshu,
We used to have similar requirements in my workplace.
We tried multiple options like snapshot and restore it but the best one
which worked for us was making a same number of nodes of cas cluster in
preprod and doing a parallel scp of the data directly from production to
preprod and then
If you have equivalent number of nodes then use snapshot to backup and then
restore them on Dev. You will need to create the schema on the Dev box. The
CFiD will be different so at most you may have to rename the Prod sstable dirs
to match whats on Dev.
Another method is to use sstableloader if