Updating Managed Service for Trino catalog settings
If you have a catalog in your Trino cluster, you can update the catalog’s settings.
Note
When you update a catalog, Managed Service for Trino recreates the cluster. While the new configuration is being applied, the cluster switches to Updating, and active queries get interrupted. For more information, see Updating a cluster.
-
Open the
TrinoCatalogresource file, e.g., using theopen trinocatalog.yamlcommand. -
Edit the properties of the selected catalog type.
General properties:
spec.<type>.url: Data source addressspec.<type>.additionalProperties: Advanced connector settings.
For PostgreSQL and ClickHouse catalogs, the following properties are also available:
spec.<type>.credentialsSecretRef: Reference to the Secret with credentials.spec.<type>.certificateSecretRef: Reference to the Secret with a TLS certificate.
The
spec.cluster,spec.name, andspec.typefields are immutable:spec.clusterandspec.namemake up the resource name (metadata.name), and modifyingspec.typeis not supported.For Iceberg catalogs, the following properties are also available:
spec.iceberg.rest.warehouse: REST catalog name.spec.iceberg.rest.oauth2: Authentication parameters (static token or client credentials).spec.iceberg.s3: S3 storage settings.spec.iceberg.stacklandStorage.bucketRef: Link to an Object Storage bucket.
-
Apply the manifest:
kubectl apply -f trinocatalog.yaml -n <namespace>.
If you store credentials in a Secret, update the Secret independently. You do not need to rename the secret name or keys.
-
If you have not opened a project yet, select one.
-
Select the namespace the cluster was created in.
-
In the left-hand menu, select Trino → Clusters.
-
Select the cluster and open the Catalogs tab.
-
Select the catalog.
-
Click Edit.
-
Edit the catalog configuration under Catalog settings. The Name and Type fields are read-only.
The Secret fields, such as Password, Access token, Client secret, and Secret access key, are empty. If you save them as is, the existing Secret values will remain unchanged. Enter a new value to update the secret.
In the Additional settings section, the key is read-only for existing rows; you can only change the value. Still, you can add new keys.
-
Click Save.
Done. The catalog settings have been updated.