Crunchy Data Warehouse
Crunchy Data Warehouse is a modern, high performance analytics database built into Postgres. It is available as a managed service on AWS via Crunchy Bridge.
Included in the Crunchy Data Warehouse documentation is:
- Concepts
- Getting started
- Storage
- Iceberg tables
- Data lake files and formats
- Spatial
- Caching
- Connecting your Postgres resources
- Plans and pricing
Crunchy Data Warehouse provides many new features in Postgres to use with analytical workloads, including:
- Executing high performance analytical queries
- Reading, writing and making updates to Iceberg tables in S3
- Querying raw CSV/JSON/Parquet files from your data lake
- Flexible data import/export between Postgres and cloud managed storage
- Seamless integration with existing database tooling
Crunchy Data Warehouse provides superior ease of use and flexibility. You can store data in Iceberg tables backed by scalable object storage, or directly query and import from cloud-based Parquet, CSV, JSON, and various geospatial file formats. It brings Iceberg tables, external lake analytics tables, and Postgres heap tables together under one unified and enhanced Postgres experience.
In addition, Crunchy Data Warehouse supports a number of powerful data import and export features. For instance, it provides the ability to generate an Iceberg table directly from a file or from your Postgres database.
Crunchy Data Warehouse replaces the earlier Crunchy Bridge for Analytics product with a much expanded feature set and an improved user experience. If you're already using Crunchy Bridge for Analytics, you can simply resize your cluster in-place and choose a Crunchy Data Warehouse cluster type.