Reference - EDB Postgres® AI Lakehouse

Suggest edits

EDB Postgres® AI Lakehouse is an early product. Eventually, it will support deployment modes across multiple clouds and on-premises. However, currently it's fairly limited in terms of where you can deploy it and what data you can query with it.

To get the best experience with Lakehouse, you should follow the Quick start to query benchmarking data. Then you can try loading your own data with Lakehouse Sync or you can bring your own data and use external tables. If you're intrigued, reach out to us and we can talk more about your use case and potential opportunities.

This section details some of the important things you should know.

Supported cloud providers and regions

Supported cloud providers and regions for Lakehouse

Supported AWS instances

Supported AWS instances for Lakehouse

Benchmarking datasets

Benchmarking datasets available for Lakehouse

Queries

Supported queries in Lakehouse and best practices when composing them

Functions

Reference for the functions provided by the PGAA extension

DirectScan

Lakehouse is fastest when it can "push down" your entire query to DataFusion. This explains how to check if your query is running in DirectScan mode.

User management

Managing users in Lakehouse

Delta Lake Table tools

Tools for working with Delta Lake Tables

Loading data

How to load data into Lakehouse


Could this page be better? Report a problem or suggest an addition!