Hi Community, Can the dimension tables be created across different tenants with the same name ?

Table names need to be unique within a Pinot cluster.

To my understanding, a table can only be associated with one tenant. If tenant is not specified, then it goes to DeafultTeant. But since dimension table normally is small, it’s would be fine to duplicate with it in another tenant but with different name.

Yes, it can be duplicated (with different name of course). You can still have a single push job that can push data to multiple tables.

With hybrid table, the lookup() query becomes tricky if the realtime and offline tables are in different tenants (as the dimension table names are different).

But you can have multiple tenants for a server/broker. So you could create a dedicated tenant for dim table and mark the realtime and offline servers with that additional tenant.

Thanks @User. Is there a document on

mark the realtime and offline servers with that additional tenant

?