[Bug]: Cassandra Integration Enforces User/Password Even When Authentication is not Enabled

[MinuraPunchihewa]

Short description of current behavior

The Cassandra integration is not able to handle situations where the database itself does not require authentication. The integration enforces user/password authentication and looks for the user and password parameters even when it is not required.

Video or screenshots

No response

Expected behavior

Users should be able to run a query similar to the following without an issue:

CREATE DATABASE sc
WITH
  engine = "cassandra",
  parameters = {
    "host": "127.0.0.1",
    "port": "9043",
    "keyspace": "test_data",
  };

How to reproduce the error

No response

Anything else?

No response