topic Databricks federation query why not support Oracle Database? in Data Engineering

Databricks federation query why not support Oracle Database?

829023 — Fri, 31 May 2024 03:54:48 GMT

Hi,

Based on the documents(https://docs.databricks.com/en/query-federation/index.html), Databricks federation query is not support Oracle for source.

1. Did you guys know the reason? (Is it depends on Oracle's speciality?)

2. Is there another way to run federation query to Oracle?

Regards,

Daniel Lee

Re: Databricks federation query why not support Oracle Database?

PiotrU — Fri, 13 Dec 2024 12:47:36 GMT

Probably someone from Databricks will write that - but it's here already

https://learn.microsoft.com/en-us/azure/databricks/query-federation/oracle

Re: Databricks federation query why not support Oracle Database?

VZLA — Fri, 13 Dec 2024 15:43:21 GMT

@829023 There's limited support with respect to the pushdown and data types mapping as documented in our website:
https://docs.databricks.com/en/query-federation/oracle.html
This was published recently, I believe in October, given your question was raised months back, like @PiotrU we're glad to let you know is now in the (preview)supported list.