L P V
08/13/2025, 10:18 AMCREATE TABLE src.kafka.kafka_transactions (
id BIGINT,
type STRING,
amount DOUBLE
) WITH (
'connector' = 'kafka',
'topic' = 'core-transaction-item',
'properties.bootstrap.servers' = 'generic.kafka.db-dev:9092',
'properties.group.id' = 'flink-sql-transactionitem',
'scan.startup.mode' = 'earliest-offset',
'format' = 'protobuf',
'protobuf.message-class-name' = 'TransactionItem',
'properties.security.protocol' = 'SASL_PLAINTEXT',
'properties.sasl.mechanism' = 'SCRAM-SHA-512',
'properties.sasl.jaas.config' = 'org.apache.kafka.common.security.scram.ScramLoginModule required username="${KAFKA_USERNAME}" password="${KAFKA_PASSWORD}";'
);
---> but it's not work. Seem flink sql client can not read directly KAFKA_USERNAME even I passed them when start sql client like this:
./bin/sql-client.sh gateway --endpoint 0.0.0.0:8083 -Drest.address=xxxx -Drest.port=8081 \
-DKAFKA_USERNAME="$KAFKA_USERNAME" \
-DKAFKA_PASSWORD="$KAFKA_PASSWORD"
So is there anyway I could pass Kafka credential to flink sql?
This syntax run correctly if I use plaintext for KAKFA_USERNAME / Password instead env variable.Taranpreet Kaur
08/19/2025, 7:05 AM