Keyvault reference for federated connection setup - Azure

[yorkuDE01]

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?

 

 

[Nivethan_Venkat · Accepted solution]

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

[yorkuDE01]

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

Many thanks Nivethan.