Connecting a data source to Trino
This is done using a juju action and configuration values passed as parameters to this action.
# Add a catalog:
juju run trino-k8s/0 add-connector conn-name=name conn-config="connector.name=postgresql
connection-url=jdbc:postgresql://host:port/database
connection-user=user
connection-password=password"
Note: the fields required can change sigificantly by database type, see supported connectors and their properties files here.
The user provided should have the maximum permissions you would want any user to have. Restrictions to access can be made on this user but no further permissions can be granted.
Removing a catalog from Trino
To remove a catalog you must provide the full configuration of that catalog. The user and password must match those that the connection was established with. It is not enough for them to have permissions to the catalog. For this reason we recommend creating a distinct trino user for this connection.
# Remove a catalog:
juju run trino-k8s/0 remove-connector conn-name=name conn-config="connector.name=postgresql
connection-url=jdbc:postgresql://host:port/database
connection-user=user
connection-password=password"
Connecting catalog clusters
In order to connect clustered database systems to Trino please connect the read-only and read-write endpoints with 2 separate juju actions. The read-only database should be appended with _ro to distinguish between the two.
salesforce #read-write endpoint
salesforce_ro #read-only endpoint
Contributing
Please see the Juju SDK documentation for more information about developing and improving charms and Contributing for developer guidance.
License
The Charmed Trino K8s Operator is free software, distributed under the Apache Software License, version 2.0. See License for more details.