Adding a Mapping to a Kafka Data Connection

Sign into the Cloud console.

Select the cluster where the existing data connection is saved.

In the left navigation, select SQL to open the SQL browser.

In the Data Explorer, click Connector Wizard.

Select the Existing Connections tab and find the data connection you need to update.

Click Create a New Mapping next to it.

Enter a unique name for your mapping.

From the Choose Topic list, select the Kafka topic that you want to query. All topic names are listed using the following format: “topic name”.

Click Next Step.

Select the key/value format for the message data in your Kafka topic.

Enter the field names and associated data types for the message data that you want to query. Choose the most appropriate data type if an exact match is not available.

Click Generate Mapping Command to generate the SQL required to create the new mapping and to add it to your data connection.

Click Confirm & Run to start to query your data in the SQL browser.