I’m a complete noob in Metatron capabilities, so while I work on getting myself a test environment I will post some queries I have in mind.
First group are related to security.
1) Is it possible to limit a given user (or group) to “see” only a given set of data sources? That is, a person with higher privileges will create the user and establish a set of data sources that user can see but disallowing the creation of others (data source level access control)
2) For a given data source, is it possible to establish a “hidden” filter in such a way all queries executed by a given user will limit the results to the rows containing such filter?
For example, you share a particular data source by multiple users, but then establish the condition CLIENT ID=user ID in all the queries it makes, effectively isolating the results by users (of course, all rows have to include the client ID dimension to work) (row level access control)
In both cases these restrictions would be configured by someb
1) Sure! You can set specific data source access privileges to specific users’ personal workspaces only. You can see “publish” feature in the data source details(Management>Data storage>Data source>Click specific data source). Click “edit” and add workspaces you want to give privileges.
2) I am not sure that filtering data source to given users is possible. Cause filter is basically dependent on dashboard and charts not on the data sources.
If you need the row level access control, I think you need to separate the data source according to conditions and give them to multiple users. Integrator might help you to schedule such ETL jobs.