Mind that a new connection is really costly for C*. So at startup it's fine. but not in a liveness or readiness check imo. For the query why not select 1; ?
-- Raphael Mazelier On 25/08/2023 19:38, Shaurya Gupta wrote: > Hi community > > We want to validate cassandra connectivity from the application container > when it starts up and before it reports as healthy to K8s. Is doing > >> select * from our_keyspace.table limit 1 > > fine Or is it an inefficient query and should not be fired on a prod cluster ? > > Any other suggestions ? > -- > > Shaurya Gupta