ntkathole · Mar 14, 2026 · Feb 24, 2026 · Feb 24, 2026 · Feb 24, 2026 · Feb 24, 2026
diff --git a/.secrets.baseline b/.secrets.baseline
@@ -98,6 +98,7 @@
   * [Trino (contrib)](reference/data-sources/trino.md)
   * [Azure Synapse + Azure SQL (contrib)](reference/data-sources/mssql.md)
   * [Couchbase (contrib)](reference/data-sources/couchbase.md)
+  * [Oracle (contrib)](reference/data-sources/oracle.md)
 * [Offline stores](reference/offline-stores/README.md)
   * [Overview](reference/offline-stores/overview.md)
   * [Dask](reference/offline-stores/dask.md)
@@ -112,6 +113,7 @@
   * [Azure Synapse + Azure SQL (contrib)](reference/offline-stores/mssql.md)
   * [Clickhouse (contrib)](reference/offline-stores/clickhouse.md)
   * [Ray (contrib)](reference/offline-stores/ray.md)
+  * [Oracle (contrib)](reference/offline-stores/oracle.md)
   * [Remote Offline](reference/offline-stores/remote-offline-store.md)
 * [Online stores](reference/online-stores/README.md)
   * [Overview](reference/online-stores/overview.md)

@@ -57,3 +57,7 @@ Please see [Data Source](../../getting-started/concepts/data-ingestion.md) for a
 {% content-ref url="clickhouse.md" %}
 [clickhouse.md](clickhouse.md)
 {% endcontent-ref %}
+
+{% content-ref url="oracle.md" %}
+[oracle.md](oracle.md)
+{% endcontent-ref %}
@@ -0,0 +1,36 @@
+# Oracle source (contrib)
+
+## Description
+
+Oracle data sources are Oracle database tables.
+These are specified by a table reference (e.g. `"TRANSACTION_FEATURES"` or `"SCHEMA.TABLE"`).
+
+## Disclaimer
+
+The Oracle data source does not achieve full test coverage.
+Please do not assume complete stability.
+
+## Examples
+
+Defining an Oracle source:
+
+```python
+from feast.infra.offline_stores.contrib.oracle_offline_store.oracle_source import (
+    OracleSource,
+)
+
+driver_stats_source = OracleSource(
+    name="driver_hourly_stats",
+    table_ref="DRIVER_HOURLY_STATS",
+    event_timestamp_column="EVENT_TIMESTAMP",
+    created_timestamp_column="CREATED",
+)
+```
+
+**Note:** Oracle stores unquoted identifiers in uppercase. Reference columns using the casing shown by Oracle (e.g. `USER_ID` for unquoted identifiers).
+
+## Supported Types
+
+Oracle data sources support standard Oracle numeric, string, date, and timestamp types mapped through the ibis Oracle backend.
+For a comparison against other batch data sources, please see [here](overview.md#functionality-matrix).
+
@@ -49,3 +49,7 @@ Please see [Offline Store](../../getting-started/components/offline-store.md) fo
 {% content-ref url="ray.md" %}
 [ray.md](ray.md)
 {% endcontent-ref %}
+
+{% content-ref url="oracle.md" %}
+[oracle.md](oracle.md)
+{% endcontent-ref %}
@@ -0,0 +1,109 @@
+# Oracle offline store (contrib)
+
+## Description
+
+The Oracle offline store provides support for reading [OracleSources](../data-sources/oracle.md).
+* Entity dataframes can be provided as a SQL query or as a Pandas dataframe.
+* Uses the [ibis](https://ibis-project.org/) Oracle backend (`ibis.oracle`) for all database interactions.
+* Only one of `service_name`, `sid`, or `dsn` may be set in the configuration.
+
+## Disclaimer
+
+The Oracle offline store does not achieve full test coverage.
+Please do not assume complete stability.
+
+## Getting started
+
+Install the Oracle extras:
+
+```bash
+pip install 'feast[oracle]'
+```
+
+## Example
+
+{% code title="feature_store.yaml" %}
+```yaml
+project: my_project
+registry: data/registry.db
+provider: local
+offline_store:
+  type: oracle
+  host: DB_HOST
+  port: 1521
+  user: DB_USERNAME
+  password: DB_PASSWORD
+  service_name: ORCL
+online_store:
+  path: data/online_store.db
+```
+{% endcode %}
+
+Connection can alternatively use `sid` or `dsn` instead of `service_name`:
+
+```yaml
+# Using SID
+offline_store:
+  type: oracle
+  host: DB_HOST
+  port: 1521
+  user: DB_USERNAME
+  password: DB_PASSWORD
+  sid: ORCL
+
+# Using DSN
+offline_store:
+  type: oracle
+  host: DB_HOST
+  port: 1521
+  user: DB_USERNAME
+  password: DB_PASSWORD
+  dsn: "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DB_HOST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))"
+```
+
+### Configuration reference
+
+| Parameter      | Required | Default     | Description                                              |
+| :------------- | :------- | :---------- | :------------------------------------------------------- |
+| `type`         | yes      | —           | Must be set to `oracle`                                  |
+| `user`         | yes      | —           | Oracle database user                                     |
+| `password`     | yes      | —           | Oracle database password                                 |
+| `host`         | no       | `localhost` | Oracle database host                                     |
+| `port`         | no       | `1521`      | Oracle database port                                     |
+| `service_name` | no       | —           | Oracle service name (mutually exclusive with sid and dsn) |
+| `sid`          | no       | —           | Oracle SID (mutually exclusive with service_name and dsn) |
+| `database`     | no       | —           | Oracle database name                                     |
+| `dsn`          | no       | —           | Oracle DSN string (mutually exclusive with service_name and sid) |
+
+## Functionality Matrix
+
+The set of functionality supported by offline stores is described in detail [here](overview.md#functionality).
+Below is a matrix indicating which functionality is supported by the Oracle offline store.
+
+|                                                                    | Oracle |
+| :----------------------------------------------------------------- | :----- |
+| `get_historical_features` (point-in-time correct join)             | yes    |
+| `pull_latest_from_table_or_query` (retrieve latest feature values) | yes    |
+| `pull_all_from_table_or_query` (retrieve a saved dataset)          | yes    |
+| `offline_write_batch` (persist dataframes to offline store)        | yes    |
+| `write_logged_features` (persist logged features to offline store) | yes    |
+
+Below is a matrix indicating which functionality is supported by `OracleRetrievalJob`.
+
+|                                                       | Oracle |
+| ----------------------------------------------------- | ------ |
+| export to dataframe                                   | yes    |
+| export to arrow table                                 | yes    |
+| export to arrow batches                               | no     |
+| export to SQL                                         | no     |
+| export to data lake (S3, GCS, etc.)                   | no     |
+| export to data warehouse                              | no     |
+| export as Spark dataframe                             | no     |
+| local execution of Python-based on-demand transforms  | yes    |
+| remote execution of Python-based on-demand transforms | no     |
+| persist results in the offline store                  | yes    |
+| preview the query plan before execution               | no     |
+| read partitioned data                                 | no     |
+
+To compare this set of functionality against other offline stores, please see the full [functionality matrix](overview.md#functionality-matrix).
+
@@ -402,7 +402,7 @@ var ValidOfflineStoreFilePersistenceTypes = []string{
 // OfflineStoreDBStorePersistence configures the DB store persistence for the offline store service
 type OfflineStoreDBStorePersistence struct {
 	// Type of the persistence type you want to use.
-	// +kubebuilder:validation:Enum=snowflake.offline;bigquery;redshift;spark;postgres;trino;athena;mssql;couchbase.offline;clickhouse;ray
+	// +kubebuilder:validation:Enum=snowflake.offline;bigquery;redshift;spark;postgres;trino;athena;mssql;couchbase.offline;clickhouse;ray;oracle
 	Type string `json:"type"`
 	// Data store parameters should be placed as-is from the "feature_store.yaml" under the secret key. "registry_type" & "type" fields should be removed.
 	SecretRef corev1.LocalObjectReference `json:"secretRef"`
@@ -422,6 +422,7 @@ var ValidOfflineStoreDBStorePersistenceTypes = []string{
 	"couchbase.offline",
 	"clickhouse",
 	"ray",
+	"oracle",
 }
 
 // OnlineStore configures the online store service

@@ -1631,6 +1631,7 @@ spec:
                                 - couchbase.offline
                                 - clickhouse
                                 - ray
+                                - oracle
                                 type: string
                             required:
                             - secretRef
@@ -7341,6 +7342,7 @@ spec:
                                     - couchbase.offline
                                     - clickhouse
                                     - ray
+                                    - oracle
                                     type: string
                                 required:
                                 - secretRef

@@ -1631,6 +1631,7 @@ spec:
                                 - couchbase.offline
                                 - clickhouse
                                 - ray
+                                - oracle
                                 type: string
                             required:
                             - secretRef
@@ -7341,6 +7342,7 @@ spec:
                                     - couchbase.offline
                                     - clickhouse
                                     - ray
+                                    - oracle
                                     type: string
                                 required:
                                 - secretRef

@@ -1639,6 +1639,7 @@ spec:
                                 - couchbase.offline
                                 - clickhouse
                                 - ray
+                                - oracle
                                 type: string
                             required:
                             - secretRef
@@ -7349,6 +7350,7 @@ spec:
                                     - couchbase.offline
                                     - clickhouse
                                     - ray
+                                    - oracle
                                     type: string
                                 required:
                                 - secretRef

diff --git a/pixi.lock b/pixi.lock
diff --git a/pyproject.toml b/pyproject.toml
@@ -102,6 +102,7 @@ mongodb = [
     "dnspython>=2.0.0",
 ]
 mssql = ["ibis-framework[mssql]>=10.0.0"]
+oracle = ["ibis-framework[oracle]>=10.0.0"]
 mysql = ["pymysql", "types-PyMySQL"]
 openlineage = ["openlineage-python>=1.40.0"]
 opentelemetry = ["prometheus_client", "psutil"]
@@ -152,7 +153,7 @@ test = [
 ]
 
 ci = [
-    "feast[test, aws, azure, cassandra, clickhouse, couchbase, delta, docling, duckdb, elasticsearch, faiss, gcp, ge, go, grpcio, hazelcast, hbase, ibis, image, k8s, mcp, milvus, mssql, mysql, openlineage, opentelemetry, spark, trino, postgres, pytorch, qdrant, rag, ray, redis, singlestore, snowflake, sqlite_vec]",
+    "feast[test, aws, azure, cassandra, clickhouse, couchbase, delta, docling, duckdb, elasticsearch, faiss, gcp, ge, go, grpcio, hazelcast, hbase, ibis, image, k8s, mcp, milvus, mssql, mysql, openlineage, opentelemetry, oracle, spark, trino, postgres, pytorch, qdrant, rag, ray, redis, singlestore, snowflake, sqlite_vec]",
     "build",
     "virtualenv==20.23.0",
     "dbt-artifacts-parser",

@@ -5,6 +5,9 @@
 from feast.infra.offline_stores.contrib.athena_offline_store.athena_source import (
     AthenaSource,
 )
+from feast.infra.offline_stores.contrib.oracle_offline_store.oracle_source import (
+    OracleSource,
+)
 from feast.infra.offline_stores.file_source import FileSource
 from feast.infra.offline_stores.redshift_source import RedshiftSource
 from feast.infra.offline_stores.snowflake_source import SnowflakeSource
@@ -56,6 +59,7 @@
     "PushSource",
     "RequestSource",
     "AthenaSource",
+    "OracleSource",
     "Project",
     "FeastVectorStore",
 ]
@@ -0,0 +1 @@
+