/

Connecting

Connecting SchemaHero to a SQLite database

The following parameters are supported when connecting to Cassandra:

NameDescription
hostsA string array containing one or more hosts to connect to. If the port is non-standard, include it in the host.
keyspaceThe keyspace to connect to. To support multiple keyspaces, include multiple database custom resources.
username (optional)The username to use when authenticating
password (optional)The password to use when authenticating

Note: keyspace, username and password can be supplied on in the custom resource or reference a secret.

apiVersion: databases.schemahero.io/v1alpha4
kind: Database
metadata:
  name: my-database
spec:
  connection:
    cassandra:
      hosts: ["10.1.1.1", "10.1.1.2"]
      keyspace: "my-keyspace"

Alternatively, it's possible to read the URI from a Kubernetes Secret:

apiVersion: v1
kind: Secret
metadata:
  name: cassandra-secret
data:
  username: dXNlcm5hbWU=
  password: cGFzc3dvcmQ=
---
apiVersion: databases.schemahero.io/v1alpha4
kind: Database
metadata:
  name: my-database
spec:
  connection:
    cassandra:
      hosts: ["10.1.1.1", "10.1.1.2"]
      keyspace: "my-keyspace"
      username:
        valueFrom:
          secretKeyRef:
            name: cassandra-secret
            key: username
      password:
        valueFrom:
          secretKeyRef:
            name: cassandra-secret
            key: password
Edit on GitHub