Practical application and core solutions

Practical application and core solutions#

Build on foundational knowledge and begin applying key Analytics Accelerator technologies in your environment.

What you will learn#

  • How to set up and query EDB Postgres Lakehouse clusters

  • How to work with Apache Iceberg and Delta Lake tables

  • How to implement tiered tables with PGD

  • How to connect BI tools to the Analytics Accelerator

  • How to apply these technologies to BI reporting, historical data analysis, and operational analytics

Before you begin#

Suggested learning path#

  1. Create a Lakehouse cluster

  2. Configure an Iceberg REST catalog connection

  3. Query existing Apache Iceberg tables

  4. Query Delta Lake tables

  5. Configure PGD node group for analytics offload

  6. Configure BDR AutoPartition with analytics offload

  7. Query Tiered Tables from PGD and Lakehouse

  8. Connect BI tools to the Lakehouse (as appropriate)

Next steps#

Once you’ve completed 201, continue with:

👉

Contents