Keyvault reference for federated connection setup - Azure

yorkuDE01
New Contributor II

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?

Screenshot 2025-03-07 at 12.39.22 PM.png

Nivethan_Venkat
Databricks MVP

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

View solution in original post

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

Many thanks Nivethan.