Add `Database` support in Pinot

[shounakmk219]

Overview

Pinot needs a way to logically group the tables in order to achieve ease of use at a large scale of users. This discussion is initiated in order to address the issues around the need to have unique table names across the cluster and lack of one level higher logical grouping of tables for better isolation and management.

Goals

• Logical grouping of tables using database
• Provide logical table naming isolation so two tables with the same name can coexist in the same cluster under different database name
• Impose access control at database level

Proposal

Please find details in the linked doc

PRs Tracking

• Allow dot in table name throughout Remove the feature flag allow.table.name.with.database #12402
• Allow passing database context through database http header #12417
• Add a way to pass database context as header from swagger UI #12695
• [multistage] support database in v2 #12591

[npawar]

Thanks @shounakmk219 !
@yupeng9 @siddharthteotia @xiangfu0 please take a look at the PEP
cc @walterddr @Jackie-Jiang @snleee

[NihalJain]

Hi watchers, posted proposal for "Database Support in Pinot UI" at #14068 (comment). PTAL!