Discuss with expertTry it for free
© 2026 Direct Cursus Technology L.L.C.

Updating Managed Service for Trino catalog settings

Written by
Updated at October 30, 2026
View in Markdown

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 system applies the new configuration, the cluster status switches to Updating and all active queries are terminated. For more information, see Updating a cluster.

  1. Open the TrinoCatalog resource file, e.g., using the open trinocatalog.yaml command.

  2. Edit the properties of the selected catalog type.

    For PostgreSQL and ClickHouse® catalogs, you can configure the following properties in the spec.postgres and spec.clickhouse sections, respectively:

    • url: Data source address.
    • credentialsSecretRef: Reference to the Secret with credentials.
    • certificateSecretRef: Reference to the Secret with a TLS certificate.
    • additionalProperties: Additional connector settings.

    An Apache Iceberg™ catalog supports the following properties:

    • spec.stacklandRestCatalog.catalogRef: StacklandRestCatalog resource name in the same namespace. When selecting a different catalog, make sure it is ready for use and Trino users have the access permissions for it.
    • spec.stacklandRestCatalog.useExternalEndpoint: Using an external catalog address. To set it to true, you need to configure public access and fill the status.externalEndpoint field for the catalog.
    • spec.stacklandRestCatalog.additionalProperties: Additional Iceberg settings, i.e., data format and compression, file size, filter requirements for queries, statistics, storage options, and Iceberg view support. Use this example of creating a catalog to add the properties and edit them as needed. When creating views, specify SECURITY INVOKER; for more information, see Iceberg views.

    There must be a single section with connector settings in the manifest. spec.type is not used. The spec.cluster and spec.name values must match the metadata.name resource name in <spec.name>-<spec.cluster> format.

  3. 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.

  1. If you have not opened a project yet, select one.

  2. Select the namespace the cluster was created in.

  3. In the left-hand menu, select Trino → Clusters.

  4. Select the cluster and open the Catalogs tab.

  5. Select the catalog.

  6. Click Edit.

  7. Edit the catalog configuration under Catalog settings. The Name and Type fields are read-only.

    For PostgreSQL and ClickHouse®, the Password field is empty. If you save it empty, the existing secret value will remain unchanged. Enter a new value to update the Secret.

    For Apache Iceberg™, you can select a different REST Catalog in the same namespace and change the Access method to Internal or External. The External method is available if the catalog you select has an external address. Make sure users have the access permissions for the new catalog.

    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.

  8. Click Save.

Done. The catalog settings have been updated.

Previous
Creating a catalog
Next
Deleting a folder