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