How-To Guides for Analytics in Hybrid Manager

Suggest edits

This section provides step-by-step guides for configuring and using core analytics features within your Hybrid Manager (HM) environment:

Deploying and managing Lakehouse Clusters for advanced analytical queries
Configuring and querying Apache Iceberg tables
Configuring and querying Delta Lake tables
Implementing and managing Tiered Tables with EDB Postgres Distributed (PGD)

For conceptual background, see Analytics Concepts in Hybrid Manager.

Getting Started

Create a Lakehouse Cluster

Next: Working with Apache Iceberg

Working with Apache Iceberg

Next: Working with Delta Lake

Working with Delta Lake

Next: Implementing Tiered Tables

Implementing Tiered Tables

Configure Tiered Tables

Monitor and Operate Tiered Tables

Next: Use Cases for Analytics in Hybrid Manager

Explore Further

Use these How-To Guides to configure and operate advanced analytics features in Hybrid Manager. To match features to your business needs, see Use Cases for Analytics in Hybrid Manager. For role-specific guidance, visit the Persona-Based Guide.

Configure PGFS for Delta Lake

How to configure a PGFS storage location for Delta Lake tables in object storage on an HM-managed Lakehouse cluster.

Configure Iceberg catalog

Step-by-step guide to configure an Iceberg REST catalog connection in Hybrid Manager for querying Iceberg tables from Lakehouse clusters or PGD nodes.

Configure AutoPartition

Learn how to configure BDR AutoPartition on a PGD table for Tiered Tables with analytics offload.

Configure PGD offload

Learn how to configure a PGD node group in Hybrid Manager to offload data to object storage for Tiered Tables.

Configure PGFS

Learn how to configure a PGFS storage location in Hybrid Manager to use for Tiered Table offloading.

Create cluster

Step-by-step guide to create a Lakehouse cluster in Hybrid Manager for fast analytics on object storage.

Monitor Tiered Tables

Learn how to monitor the status of Tiered Tables, track offload progress, and observe storage savings in Hybrid Manager.

Offload PGD to Iceberg

Guide to offloading PGD data to Apache Iceberg with Hybrid Manager, including when and why to use this capability.

Performance tuning for Delta Lake queries

How to tune and optimize performance when querying Delta Lake tables from an HM-managed Lakehouse cluster.

Query Delta Lake tables

How to query Delta Lake tables in object storage from an HM-managed EDB Postgres Lakehouse cluster.

Query Iceberg tables

How to query existing Apache Iceberg tables from EDB Postgres Lakehouse clusters in Hybrid Manager.

Query Tiered Tables

Learn how to query Tiered Tables from PGD and Lakehouse clusters in Hybrid Manager.

← Prev

Analytics Concepts in Hybrid Manager

↑ Up

Learning Analytics in Hybrid Manager