Analytics Accelerator 201 Practical application and core solutions v1.3

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

• Level 101: Foundational concepts
• Generic analytics concepts
• Analytics Accelerator concepts

Suggested learning path

1. Lakehouse overview
2. Apache Iceberg® overview
3. Delta Lake overview
4. Tiered Tables concepts
5. Create a Lakehouse cluster
6. Read and write Iceberg tables with a catalog
7. Read Iceberg tables with or without a catalog
8. Read and write without a catalog
9. Use a third-party catalog

Next steps

Once you’ve completed 201, continue with:

• Level 301: Advanced techniques
• Reference index