topic Re: Keyvault reference for federated connection setup - Azure in Data Engineering

Keyvault reference for federated connection setup - Azure

yorkuDE01 — Fri, 07 Mar 2025 17:42:05 GMT

I am trying to create a federated connection in unity catalog for an Oracle Database. The connection configuration GUI seems to ask for the password. Is it possible to put a keyvault reference here instead?

Re: Keyvault reference for federated connection setup - Azure

Nivethan_Venkat — Fri, 07 Mar 2025 17:48:32 GMT

Hi @yorkuDE01,

I suppose this could be done when you are trying to create / setup federated connection using API. But, I don't think so this could be possible via UI, where you can reference a key-vault scoped secret.

But please refer the documentation for best practise and more inputs on Lakehouse federation: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-connection

Best Regards,
Nivethan V

Re: Keyvault reference for federated connection setup - Azure

yorkuDE01 — Fri, 07 Mar 2025 18:26:08 GMT

That worked. Even though the documentation list ORACLE as a supported type, it worked for me.

Many thanks Nivethan.