Hi Siva, seems like you are referring to three separate functions:
• datasource level security - where you use access control to restrict usage of data sources by user/role
• datasource resource usage isolation (this is what Didip refers to) segregate datasources by historical tier so it is dedicated to a tenant that has access to that data source)
• efficient data filtering on a single data source that has data for multiple tenants where you use secondary partitioning (CLUSTERED BY in SQL based ingestion) to only access segments that are relevant to the tenant at query time.