Skip to content
Closed
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
43 changes: 21 additions & 22 deletions docs/reference/offline-stores/overview.md
Original file line number Diff line number Diff line change
Expand Up @@ -30,29 +30,28 @@ There are several additional implementations contributed by the Feast community
Details for each specific offline store, such as how to configure it in a `feature_store.yaml`, can be found [here](README.md).

Below is a matrix indicating which offline stores support which methods.

|| | Dask | BigQuery | Snowflake | Redshift | Postgres | Spark | Trino | Couchbase | Ray |
|| :-------------------------------- | :-- | :-- | :-- | :-- | :-- | :-- | :-- | :-- | :-- |
|| `get_historical_features` | yes | yes | yes | yes | yes | yes | yes | yes | yes |
|| `pull_latest_from_table_or_query` | yes | yes | yes | yes | yes | yes | yes | yes | yes |
|| `pull_all_from_table_or_query` | yes | yes | yes | yes | yes | yes | yes | yes | yes |
|| `offline_write_batch` | yes | yes | yes | yes | no | no | no | no | yes |
|| `write_logged_features` | yes | yes | yes | yes | no | no | no | no | yes |
| | Dask | BigQuery | Snowflake | Redshift | Postgres | Spark | Trino | Couchbase | Ray |
| :-------------------------------- | :-- | :-- | :-- | :-- | :-- | :-- | :-- | :-- | :-- |
| `get_historical_features` | yes | yes | yes | yes | yes | yes | yes | yes | yes |
| `pull_latest_from_table_or_query` | yes | yes | yes | yes | yes | yes | yes | yes | yes |
| `pull_all_from_table_or_query` | yes | yes | yes | yes | yes | yes | yes | yes | yes |
| `offline_write_batch` | yes | yes | yes | yes | no | no | no | no | yes |
| `write_logged_features` | yes | yes | yes | yes | no | no | no | no | yes |


Below is a matrix indicating which `RetrievalJob`s support what functionality.

|| | Dask | BigQuery | Snowflake | Redshift | Postgres | Spark | Trino | DuckDB | Couchbase | Ray |
|| --------------------------------- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|| export to dataframe | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes |
|| export to arrow table | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes |
|| export to arrow batches | no | no | no | yes | no | no | no | no | no | no |
|| export to SQL | no | yes | yes | yes | yes | no | yes | no | yes | no |
|| export to data lake (S3, GCS, etc.) | no | no | yes | no | yes | no | no | no | yes | yes |
|| export to data warehouse | no | yes | yes | yes | yes | no | no | no | yes | no |
|| export as Spark dataframe | no | no | yes | no | no | yes | no | no | no | no |
|| local execution of Python-based on-demand transforms | yes | yes | yes | yes | yes | no | yes | yes | yes | yes |
|| remote execution of Python-based on-demand transforms | no | no | no | no | no | no | no | no | no | no |
|| persist results in the offline store | yes | yes | yes | yes | yes | yes | no | yes | yes | yes |
|| preview the query plan before execution | yes | yes | yes | yes | yes | yes | yes | no | yes | yes |
|| read partitioned data | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes |
| | Dask | BigQuery | Snowflake | Redshift | Postgres | Spark | Trino | DuckDB | Couchbase | Ray |
| --------------------------------- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| export to dataframe | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes |
| export to arrow table | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes |
| export to arrow batches | no | no | no | yes | no | no | no | no | no | no |
| export to SQL | no | yes | yes | yes | yes | no | yes | no | yes | no |
| export to data lake (S3, GCS, etc.) | no | no | yes | no | yes | no | no | no | yes | yes |
| export to data warehouse | no | yes | yes | yes | yes | no | no | no | yes | no |
| export as Spark dataframe | no | no | yes | no | no | yes | no | no | no | no |
| local execution of Python-based on-demand transforms | yes | yes | yes | yes | yes | no | yes | yes | yes | yes |
| remote execution of Python-based on-demand transforms | no | no | no | no | no | no | no | no | no | no |
| persist results in the offline store | yes | yes | yes | yes | yes | yes | no | yes | yes | yes |
| preview the query plan before execution | yes | yes | yes | yes | yes | yes | yes | no | yes | yes |
| read partitioned data | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes |