> ## Documentation Index
> Fetch the complete documentation index at: https://docs.peerdb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Feature matrix

# WAL or Change Data Capture (CDC) Based Replication

Below table shows supported features and features we are working on for WAL or CDC Based replication from **Postgres** to different targets.
✅ means supported. 🛠️ means **Work in Progress and Coming Soon!**.

## Warehouses

| Feature                                                                                                                                                                                   | Snowflake | BigQuery | Clickhouse | Postgres | S3/GCS |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------- | -------- | ---------- | -------- | ------ |
| [Initial Snapshot - Parallelizable](https://blog.peerdb.io/parallelized-initial-load-for-cdc-based-streaming-from-postgres#heading-parallelized-initial-snapshot-for-cdc-based-streaming) | ✅         | ✅        | ✅          | ✅        | ✅      |
| Incremental Sync (CDC)                                                                                                                                                                    | ✅         | ✅        | ✅          | ✅        | ✅      |
| DML Support - INSERT, UPDATE and DELETE                                                                                                                                                   | ✅         | ✅        | ✅          | ✅        | ✅      |
| [Schema Changes](/features/schema-changes)                                                                                                                                                | ✅         | ✅        | ✅          | ✅        | ✅      |
| Soft Delete                                                                                                                                                                               | ✅         | ✅        | 🛠️        | ✅        | ✅      |
| [Partitioned Tables](/features/replicating-partitioned-tables)                                                                                                                            | ✅         | ✅        | ✅          | ✅        | ✅      |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc.                                                                                                                                   | ✅         | ✅        | ✅          | ✅        | ✅      |
| Advanced Monitoring - Lag, Throughput, Postgres Wait Events etc                                                                                                                           | ✅         | ✅        | ✅          | ✅        | ✅      |
| Resync Mirrors                                                                                                                                                                            | ✅         | ✅        | ✅          | ✅        | ✅      |
| Column Exclusion                                                                                                                                                                          | ✅         | ✅        | ✅          | ✅        | ✅      |
| Add Tables                                                                                                                                                                                | ✅         | ✅        | ✅          | ✅        | ✅      |

## Queues

| Feature                                                                                                                                                                                   | EventHubs | Kafka | Redpanda | PubSub |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------- | ----- | -------- | ------ |
| [Initial Snapshot - Parallelizable](https://blog.peerdb.io/parallelized-initial-load-for-cdc-based-streaming-from-postgres#heading-parallelized-initial-snapshot-for-cdc-based-streaming) | 🛠️       | ✅     | ✅        | ✅      |
| Incremental Sync (CDC)                                                                                                                                                                    | ✅         | ✅     | ✅        | ✅      |
| DML Support - INSERT, UPDATE and DELETE                                                                                                                                                   | ✅         | N/A   | N/A      | N/A    |
| [Schema Changes](/features/schema-changes)                                                                                                                                                | ✅         | 🛠️   | 🛠️      | 🛠️    |
| [Partitioned Tables](/features/replicating-partitioned-tables)                                                                                                                            | ✅         | ✅     | ✅        | ✅      |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc.                                                                                                                                   | ✅         | ✅     | ✅        | ✅      |
| Advanced Monitoring - Lag, Throughput, Postgres Wait Events etc                                                                                                                           | ✅         | ✅     | ✅        | ✅      |
| Resync Mirrors                                                                                                                                                                            | 🛠️       | N/A   | N/A      | N/A    |
| Column Exclusion                                                                                                                                                                          | ✅         | ✅     | ✅        | ✅      |

# Query Based or Watermark Based Replication

Below table shows supported features and features we are working on for Query Based or Watermark Based Replication from **Postgres** to different targets.
✅ means supported. 🛠️ means **Work in Progress and Coming Soon!**.

| Feature                                                                 | Snowflake | BigQuery | Postgres | S3/GCS |
| ----------------------------------------------------------------------- | --------- | -------- | -------- | ------ |
| Initial Snapshot                                                        | ✅         | ✅        | ✅        | ✅      |
| Incremental Sync Based on Watermark                                     | ✅         | ✅        | ✅        | ✅      |
| DML Support - INSERT, UPDATE (if updated\_at & primary key are present) | ✅         | ✅        | ✅        | ✅      |
| Schema Changes - ADD COLUMN                                             | ✅         | 🛠️      | 🛠️      | 🛠️    |
| Resync Mirrors                                                          | ✅         | 🛠️      | 🛠️      | 🛠️    |
| Partitioned Tables                                                      | ✅         | ✅        | ✅        | ✅      |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc.                 | ✅         | ✅        | ✅        | ✅      |
| Advanced Monitoring - Throughput, Postgres Wait Events etc              | ✅         | ✅        | ✅        | ✅      |
| Column Exclusion                                                        | ✅         | ✅        | ✅        | ✅      |

# Transformations

Below table shows what targets we support transformations and their status

| Target           | Status          |
| ---------------- | --------------- |
| EventHubs        | ✅               |
| Kafka / Redpanda | ✅               |
| PubSub           | ✅               |
| Snowflake        | Private Preview |
| BigQuery         | Private Preview |
| Clickhouse       | Private Preview |
| Postgres         | Private Preview |
| S3/GCS           | Private Preview |