Hi Everyone
Does anyone have some examples of managing Secrets in Flink Sql. The Connectors like Kafka generally require secrets for connecting and I want to avoid placing it in Sql Scripts? For example can you reference an Env Var inside a SQL script?
Thanks
b
Ben Gamble
04/11/2025, 12:35 PM
Make a catalogue with the credentials and use that?
g
Gert Humphris
04/13/2025, 8:24 PM
Thanks Ben that is an option. It looks like Pyflink might be a better option for standing up Connectors etc. as it can handle things like Secrets and configuration better.
b
Ben Gamble
04/13/2025, 8:34 PM
That always works :)
Pyflink is not without it's own issues, but it's a good approach.
We've got a secrets manager which works with SQL baked into our offering so I tend to forget the table API options.