Can I restore a keyspace with a different schema?

I had to DROP a keyspace. Now I want to restore it from a backup - I want the data back, but I want to configure different schema options.
Can I do it upon restore? Or do I have to restore the keyspace first and ALTER it later?

Using Create+Alter or just Create with the new option, doesn’t make a difference.
What makes a difference is what options you want to change.
You can change the replication options, but note that when restoring the data, you have to take the changes into account, you will probably have to use nodetool refresh --load-and-stream.

1 Like