Oracle Lakehouse Federaton with CA Certificate

[AntonDBUser]

Hi!

We have been pulling data from Oracle to Databricks by installing Oracle Driver and certificates directly in the cluster. We are now looking into using Lakehouse Federation for Oracle instead, but it seems like the connection doesn't pick up the certificate. Has anyone found a solution or workaround for this? We are really eager to switch to Lakehouse Federation!

BR,
Anton

[Isi]

Hi @AntonDBUser ,

Thanks for sharing your experience, we’re looking into using Lakehouse Federation with Oracle too.

I haven’t tested this myself, but one idea that came to mind is whether switching from a serverless cluster to a standard (Pro) cluster might help. In Pro clusters, you usually have more control over the environment, so perhaps installing the truststore or Oracle cert manually could work in combination with Federation. Again, just a hypothesis — I haven’t tried it yet.

Also, if you don’t mind, could you please share how Lakehouse Federation is working for you overall?

• Are external databases queries doing a full table scan even when using filters in the SQL query?

• Have you noticed a delay in execution time compared to native Delta tables or regular JDBC?

Best regards,

Isi