How-To Guides for Analytics in Hybrid Manager

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 .

Working with Apache Iceberg

• Configure an Iceberg REST catalog connection

• Query existing Apache Iceberg tables

• Offload PGD data to Apache Iceberg

Next: Working with Delta Lake

Implementing Tiered Tables

Configure Tiered Tables

• Configure PGFS storage for Tiered Tables

• Configure PGD node group for analytics offload

• Configure BDR AutoPartition with analytics offload

Monitor and Operate Tiered Tables

• Monitor Tiered Tables status and storage savings

• Query Tiered Tables from PGD and Lakehouse

Next: Solving Business Problems with Analytics in Hybrid Manager

Use these How-To Guides to configure and operate advanced analytics features in Hybrid Manager. To match features to your business needs, see Solving Business Problems with Analytics in Hybrid Manager . For role-specific guidance, visit the Leveraging Analytics in Hybrid Manager .

• Configure PGFS for Delta Lake
  • Prerequisites
  • Steps
    • Step 1: Create PGFS storage location
    • Example: Public bucket
    • Example: Private bucket (AWS S3)
    • Step 2: Validate PGFS location
  • Notes
  • Next steps
• Configure an Iceberg REST catalog connection
  • Goals
  • Before you start
  • Prerequisites
  • Steps
    • 1. Add catalog connection
    • 2. Attach catalog
    • 3. Import catalog (optional)
    • 4. Creating catalog-managed Iceberg tables
  • Notes
  • What this enables
  • Next steps
• Configure BDR AutoPartition with analytics offload
  • Prerequisites
  • Steps
  • Notes
  • Next steps
  • Related concepts
• Configure PGD node group for analytics offload
  • Why configure PGD node group for offload?
  • Prerequisites
  • Offloading without a catalog
    • Step 1: Identify your PGD node group
    • Step 2: Set the node group option analytics_storage_location
  • Offloading with an Iceberg catalog (recommended)
    • Step 1: Ensure your catalog is configured and attached
    • Step 2: Set the node group option analytics_write_catalog
  • Validate the configuration
  • Notes
  • Next steps
  • Related concepts
• Configure PGFS storage for Tiered Tables
  • Why configure PGFS for Tiered Tables?
  • Goals
  • Prerequisites
  • Steps
    • Step 1: Connect to your PGD node
    • Step 2: Run pgfs.create_storage_location()
    • Step 3: Validate that the PGFS storage location was created
  • Notes
  • Next steps
  • Related concepts
• Create a Lakehouse cluster
  • Why create a Lakehouse cluster?
  • Goals
  • Prerequisites
  • Steps
    • Step 1: Initiate cluster creation
    • Step 2: Choose your path
    • Step 3: Configure cluster settings
    • Cluster Settings
    • Additional Settings
    • Step 4: Review and create
  • What you can do next
  • Related topics
• Monitor Tiered Tables status and storage savings
  • Why monitor Tiered Tables?
  • Goals
  • Prerequisites
  • Monitor analytics table status
  • Monitor AutoPartition offload activity
  • Monitor storage savings on PGD
  • Advanced observability — Heap vs. Offloaded size
  • What you can do next
  • Related How-Tos
• Offload PGD data to Apache Iceberg
  • How PGD offload works in Hybrid Manager
  • Prerequisites
  • Steps to offload PGD data
    • Step 1: Ensure node group is configured for offload (required)
    • Step 2: Enable analytics replication on your table
  • Accessing offloaded data
    • If using Iceberg catalog
    • If using PGFS only (filesystem offload)
  • Notes
  • What this unlocks
  • Next steps
• Performance tuning for Delta Lake queries
  • Goals
  • When to use this
  • General best practices
    • Use partitioning effectively
    • Leverage data skipping
    • Use LIMIT and targeted projections
    • Filter early and specifically
    • Validate PGFS location proximity
    • Monitor query performance
  • Known limitations
  • Next steps
• Query Delta Lake tables
  • 1. Define a PGFS storage location
• Query existing Apache Iceberg tables
  • Goals
  • When to use this
  • Prerequisites
  • Steps
    • 1. Define a PGFS storage location
    • 2. Create PGAA external table for Iceberg
    • 3. Query the Iceberg table
  • Notes
  • Next steps
• Query Tiered Tables from PGD and Lakehouse
  • Goals
  • When to use this
  • Prerequisites
  • Querying the parent table in PGD
  • Querying offloaded data only (PGD)
  • Querying offloaded data from Lakehouse
  • Notes on planner behavior
  • Next steps