Cloudera Docs

Creating a federation connector

Learn how you can create a federation connector that can be used by a Trino Virtual Warehouse to query and access data from different data sources.

  • You must create a Trino Virtual Warehouse.
  • You must register a secret for your Environment.
  1. Log in to the Cloudera Data Warehouse service and click Federation Connectors.
    The Federation Connectors page is displayed that lists all the currently configured connectors.
  2. In the Data Source Type page, select the type of data source that you want to configure and then click Next.
    You can choose between a Cloudera Certified connector or a Community connector.
  3. In the Configuration Details page, enter the following information:
    1. Provide a catalog name and description for the connector.
    2. Select the appropriate environment.
    3. Under the Configuration pane, enter the following key-value pairs:
      • Connector name
      • Connector URL to connect to the required data source. For example, jdbc:postgresql://example.net:3306/postgres
      • Connection user name
      • Connection password - Choose a registered secret from the environment selected above.
    4. Click Test Connection to verify if the configurations are correct to establish a successful connection to the data source.

      A message is displayed indicating if the connection is successful or not. If the connection fails, modify the configuration details and try again.

    Image of a Trino Federation Connector configuration screen
  4. If the connection is successful, click Connect To Datasource to establish a connection to the data source.
The connector is created successfully and is listed in the Federation Connectors page.