There are two types of views.
New SQL View
An SQL View lets you rewrite a dataset using SQL to create a new dataset.
This type of view can be created by selecting New SQL View.
SQL can be used to select complex datasets from multiple tables, for example:
A selection of columns with calculated columns
Join data from multiple tables with calculated columns
New Graphical View
A Graphical View allows users to create complex views without using SQL.
Tables and views can be dragged onto the main canvas.
Nodes will be displayed on the graphical canvas to show stages in the transformation.
The end node is always the View.
At each node, different operations can be performed to transform the data.
Filters
Filters filter data by values in the data set. For example, this filter will only show columns where the State ID is either TX or CA:
Rename/Exclude Columns
This lets you rename columns or exclude them from the end view.
Calculated Columns
This lets you create columns derived from data from the datasets.
View Properties
The view properties let you name the Business Name and the Technical Name of the view.
- The Semantic Usage can be changed to reflect how the data in the view will be used. This can include:
- Relational Dataset
- Dimension
- Text
- Hierarchy
- Fact
- Exposure for Consumption: When turned on, will expose this view to external tools.
- In the Column/Attribute setting, the column properties, like associations and semantic type, can be changed.
- Data Persistence: Deployed views can persist a copy of the data, so it is stored in Datasphere.
- Data Access Control: Let you apply row-level security to the data. This excludes data for specific end users.
Save and Deploy
- Saving the table will add the table to the list in Data Builder.
- Deploying the table will make it active, so its saved configuration can be used in other applications.
- Data Viewer: Shows any data that is persistently stored within Datasphere.
