Keyspace creation

[wind57]

Is there a way to create the keyspace before applying change sets? Our use case is that we have multiple envs, with a lot of keyspaces, that all have different names. Ideally, creating the keyspace should be tracked by liquibase too, not as a separate activity outside liquibase lifecycle.

Am I correct that this is not possible and it is assumed that keyspace must exist? This would be a pity, since it would basically mean it is a useless tool for us :( I hope I am missing something.

Thank you

┆Issue is synchronized with this Jira Bug by Unito

[wind57]

I hoped something like this would work

"preConditions": [
        {
          "dbmsType": "cassandra",
          "onFail": "HALT",
          "sqlCheck": {
            "sql": "CREATE KEYSPACE IF NOT EXISTS Killer_Video WITH replication = {'class':'SimpleStrategy', 'replication_factor':1};",
            "expectedResult": 1
          }
        }
      ]

but this has failed no matter what I tried.

---

Oh I just saw that this is not related to cassandra, liquibase can't do that, in general. I guess, this means we will not be using this.