Set Up an Apache Impala Connection (Beta)

Set up the Apache Impala connection to start the flow of data into Data Cloud.

This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data Cloud Connector team at datacloud-connectors-beta@salesforce.com.
User Permissions Needed 
To create a connection:System Administrator

Before you begin:

  • Enable the Beta connector through the feature manager. See Enable Data Cloud Features.
  • Verify your admin has enabled firewalls on the system you want Data Cloud to connect to by including these IP addresses to your allowlists.

  1. In Data Cloud, click Setup, and select Data Cloud Setup.

  2. Under External Integrations, select Other Connectors.

  3. Click New.

  4. On the Source tab, select Apache Impala and click Next.

  5. Enter a connection name, connection API name, and provide the authentication and connection details.

  6. For Authentication Details, enter the username and password to authenticate the user.

    For a connection using Custom Certificate, enter the SSL Certificate as a string or upload the string as a .pem file.

  7. For Connection Details, choose the public or custom certificate and specify the URL, port, protocol version, database, page size, and transport mode.

    If the Apache instance is public cloud hosted, select Public Certificate. If the instance is private cloud hosted, select Custom Certificate for a private certificate to access Introducing Apache Impala.

    1. For Connection URL, provide the URL in https format.

    2. For Port, enter the port that the server is running on. The default is 21050, but it can be changed.

    3. For Protocol Version, enter a value from 1 through 11. The default is 7, but it can be changed.

    4. For Database, enter a value as a string.

    5. For Page Size, enter the number of rows retrieved in a single query request.

    6. For Transport Mode, select BINARY or HTTP from the dropdown.

      (Optional) If you select the HTTP option and want to pass the query to the Apache Impala server as is, select the Query Passthrough checkbox.

  8. To review your configuration, click Test Connection.

  9. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.