Arrow Flight service

You can directly connect to the databases in IBM® watsonx.data through the Arrow Flight service in the same CPD cluster. However, for IBM Cloud and IBM Developer edition, Arrow Flight service that is deployed on IBM Cloud is used where you need to enter the details that are related to API key and Flight service URL. This feature is applicable for both Presto (Java) and Presto (C++) engines.

watsonx.data on Red Hat® OpenShift®

watsonx.data Developer edition

About this task

Prerequisites:
  • The Arrow Flight connector supports only the IBM Arrow Flight service, either on the same CPD cluster that has IBM watsonx.data or on an IBM Cloud VM.
  • In CPD, Arrow Flight service should be installed in the same CPD cluster for the data sources to work.
  • You need to install Watson Studio in the CPD to get an instance of the Arrow Flight service.
  • The Arrow Flight service should be running for databases to work with.
Features and capabilities:
  • The databases that are supported through Arrow Flight service have better performance as compared to JDBC databases.
  • Basic query pushdown is available for queries across the tables from the same database and across the tables from different flight databases.
  • The Arrow Flight service databases support only SELECT and DESCRIBE queries.

Procedure

  1. Log in to IBM watsonx.data console.
  2. From the navigation menu, select Infrastructure manager.
  3. To define and connect a database, click Add component and select Add database.
  4. In the Add database window, select a database from the Database type drop-down list. The list includes the following database types: