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. Click Create Data Source to create a new connector.
  3. In the Data Source Type page, select the type of data source, such as PostreSQL, MySQL, Snowflake, AWSRedshift, or Default template that you want to configure and then click Next.
  4. 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
  5. If the connection is successful, click Connect To Datasource to establish a connection to the data source.
  6. Optional: If you want to associate Trino Virtual Warehouses to this connector, click Subscribe Now and you are provided with the list of available Virtual Warehouses that you can choose to associate with the connector.
The connector is created successfully and is listed in the Federation Connectors page.