Managing Materialized Data
When a Model definition file is run, it can MATERIALIZE a new database, data model or machine learning model. These materialized artifacts can be secured and managed through the Materialized Data Manager (MDM) which is a tool for end-users to self-manage their own data modeling - similar to the Data Source Manager for managing data for admins.
Accessing the Materialized Data Manager
The MDM can be accessed via the main content manager interface in the pro client (green box below). After clicking on the MDM button, a list of accessible servers, their child databases and their child data models will be presented in a data source tree (blue box below). Use the drop down data type filter (red box) or the search option (blue arrow) to narrow down the list of items in the tree.
Using the Materialized Data Manager
The MDM presents end-users with a point and click interface, allowing them to set the required security preferences easily for the databases and models they have created and own. The interface is broken into 3 layers:
- Data Server Manager: see high level information about the selected data server, set security on the server for any roles the user is a member of and review and manage databases on that server.
- Database Manager: see high level information about the selected database, set database security for any roles the user is a member of and manage any database models that the user owns.
- Data Model Manager: review general information about the data model, set model security for any roles the user is a member of.
If a user can access a database or a model, the item will appear in the list server tree listing. However, they are only given viewing rights to databases and models unless they are the owner / creator of the artifacts.