Kafka User-Defined Session Parameters
Use the following Vertica use-defined session parameters to configure Kafka SSL when not using a scheduler. The kafka_ parameters configure SSL authentication for Kafka. Refer to TLS/SSL Encryption with Kafka for more information.
Query the CONFIGURATION_PARAMETERS system table to determine what levels (node, session, user, database) are valid for a given parameter.
| Parameter | Description |
|---|---|
| kafka_SSL_CA |
The contents of the certificate authority certificate. For example: => ALTER SESSION SET UDPARAMETER kafka_SSL_CA='MIIBOQIBAAJBAIOL'; Default: none |
| kafka_SSL_Certificate |
The contents of the SSL certificate. For example: => ALTER SESSION SET UDPARAMETER kafka_SSL_Certificate='XrM07O4dV/nJ5g'; This parameter is optional when the Kafka server's parameter Default: none |
| kafka_SSL_PrivateKey_secret |
The private key used to encrypt the session. Vertica does not log this information. For example: => ALTER SESSION SET UDPARAMETER kafka_SSL_PrivateKey_secret='A60iThKtezaCk7F'; This parameter is optional when the Kafka server's parameter Default: none |
| kafka_SSL_PrivateKeyPassword_secret |
The password used to create the private key. Vertica does not log this information. For example: ALTER SESSION SET UDPARAMETER kafka_SSL_PrivateKeyPassword_secret='secret'; This parameter is optional when the Kafka server's parameter Default: none |
| kafka_Enable_SSL |
Enables SSL authentication for Vertica-Kafka integration. For example: => ALTER SESSION SET UDPARAMETER kafka_Enable_SSL=1; Default: 0 |
| MaxSessionUDParameterSize |
Sets the maximum length of a value in a user-defined session parameter. For example: => ALTER SESSION SET MaxSessionUDParameterSize = 2000 Default: 1000 |