Data mart views

By default, data mart tables are created without corresponding views. Views may be useful however because they:

• Allow authorized employees to utilize the data mart for analytics while preventing changes to the actual data.
• Can be queried without needing to worry about "locking" the data.

When you create a view for a fact or dimension table, you also need to set the schema in which the view will be created.

Additionally, the schema permissions should only allow authorized employees to access the view(s).

For instructions on setting the view schema, see Modifying data mart settings.

See also Editing star schemas and Editing dimensions.