You can only add a new mapping to an existing Kafka data connection. You cannot update an existing mapping or data connection using the connector wizard.
Adding a New Mapping to a 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.