Is it possible to have Lakebase Postgres as a compute option for an AI/BI Dashboard?

[ttsaklanos]

Can dashboards be powered by Lakebase Postgres?

I noticed I can select it in the 'Queries' editor, but it doesn't seem to be an option for dashboards, which currently only shows SQL Warehouse and Serverless.

Any way around this?
Our aim is to support a lot of concurrent users that fetch a pre-aggregated dataset, on top of which Unity Catalog ABAC policies are applied at runtime.

[Louis_Frolio · Accepted solution]

Greetings @ttsaklanos , Quick clarification up front: dashboards don’t run directly on Lakebase Postgres. They always execute on a Databricks SQL warehouse (Pro or Serverless). Today, there isn’t a way to select “Lakebase Postgres” itself as the dashboard compute.

Hope this helps, Louis.

[KartikBhatnagar]

You can register Lakebase as read-only foreign catalog. In this case both computes will be used ( Sql end point and Lakebase). Doing lots of entitlement filtering via ABAC policies when dashboard being used can be tricky. Pre aggravated MV can be a choice. 

Below are my questions to understand the problem better.

What is the expected peak number of concurrent users?

Is the aggregation level safe with ABAC filtering? Assuming you have row based filtering.

What attributes drive ABAC policies (region, business unit, etc.)?

Will ABAC require runtime joins to entitlement tables?

Which compute will serve users, and is autoscaling enabled?