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 name and description for the connector.
    2. Select the appropriate environment.
    3. Enter the appropriate URL to connect to the required data source. For example, jdbc:postgresql://example.net:3306/postgres
    4. Enter the connection username and select a registered secret for the password.
    5. 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 Next to proceed to the Review And Connect page.
    This page provides a summary of the connector and its configuration.
  6. 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.