Cloudera Docs

Backing up Trino connector configurations

Before decommissioning a Cloudera Data Warehouse environment, you must manually export Trino Federation Connector configurations. While the standard CLI backup-cluster command covers Trino entities and secrets, it does not include Federation Connector objects. Capturing these configurations manually ensures you have the metadata required to recreate them in a new environment.

  1. Identify the Cluster ID of the environment you are preparing to decommission.
  2. Open your terminal and run the following command to export all user-applied connector configurations to a JSON file: 
    cdp dw list-connectors --cluster-id <cluster-id> --profile <profile> 1>connectors.json

  3. Save the connectors.json file in a secure location to be used during the restoration phase. 
    {
    "connectors": [
        {
            "id": "connector-id-1",
            "name": "hive",
            "template": "hive",
            "config": {
                "connector.name": "hive",
                "fs.cache.ttl": "8d",
                ...
            },
            "description": "A default Hive connector is configured whenever a new Trino virtual warehouse is added to an environment",
            "createdBy": "user@example.com",
            "createdAt": 1770647956
        },
        {
            "id": "connector-id-2",
            "name": "iceberg",
            "template": "iceberg",
            "config": {
                "connector.name": "iceberg",
                "fs.cache.ttl": "8d",
                ...
            },
            "description": "A default Iceberg connector is configured whenever a new Trino virtual warehouse is added to an environment",
            "createdBy": "user@example.com",
            "createdAt": 1770647956
        }
    ]
}