Does ScyllaDb Keyspace names are Case sensitive or not?

ScyllaDB
1

When I am trying to give keyspace name as Mykeyspace1 in scylla.yaml and after restarting the Scylla service when I am executing CQL queries those audit logs are not getting capture in audit log file.

But when I am using mykeyspace1 in lower case then everything is perfectly working fine.

2

Hey @subrato,

Cassandra identifiers, such as keyspace, table and column names, are case-insensitive, unless enclosed in double quotation marks.
Consider:

cqlsh> CREATE KEYSPACE ms WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 1};
Warnings :
Using Replication Factor datacenter1=1 lower than the minimum_replication_factor_warn_threshold=3 is not recommended.
cqlsh> CREATE KEYSPACE Ms WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 1};
AlreadyExists: Keyspace 'ms' already exists
cqlsh> CREATE KEYSPACE "Ms" WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 1};
Warnings :
Using Replication Factor datacenter1=1 lower than the minimum_replication_factor_warn_threshold=3 is not recommended.
cqlsh>

You can try providing a name enclosed in the double quotation marks in scylla.yaml. Let me know if that worked for you.

1 Like