IBM Cloud Docs
Custom data source

Custom data source

You can now use the Custom data source to create data sources that are not provided by the built-in connectors. Custom data source can be used for connectors that are already supported by Presto as per the Presto documentation but not listed in IBM IBM® watsonx.data supported connectors or data sources. This feature is applicable for Presto (Java) and Presto (C++) engines. For Presto (C++) engine, only Hive, Apache Iceberg, Arrow Flight service, and Custom data sources can be associated.

To add a custom data source, complete the following steps.

  1. Log in to the watsonx.data console.

  2. From the navigation menu, select Infrastructure manager.

  3. To define and connect a data source, click Add component.

  4. In the Data sources section, select Custom data source.

  5. Configure the following details:

    Use of this feature may crash your Presto (Java) engine if configured incorrectly. IBM does not provide support for use of this feature..

    Two databases with the same name cannot be added. Custom databases do not support SSL configuration.

    Table 1. Register database
    Field Description
    Display name Enter the database name to be displayed on the screen.
    Property value Enter the properties and their values to be configured for the database. Enter the property name:value pair as specified in Presto (Java) documentation. You can add multiple properties.
    connector.name= Enter the name of the database connector that you want to add as specified in Presto (Java) documentation.
    Encryption Encrypting values of the keys are stored.
    Associated catalog Enter the name of the catalog. This catalog is automatically associated with your database.
    Create Click Create to create the data source.

You can use the Custom data source for the following connectors in IBM watsonx.data for Presto (Java) engine:

  1. Local File connector: The Local File connector is used to display the http request logs of a worker. Use the custom data source option with the following properties. For more information, see Local File connector.
  • connector.name=localfile
  • presto-logs.http-request-log.location=var/log
  • presto-logs.http-request-log.pattern=http-request.log*
  1. Black Hole connector: The Black Hole connector is designed for high-performance testing of other components. Use the custom data source option with the following property. For more information, see Black Hole connector.
  • connector.name=blackhole