Preparing Data

Users with a modeler role can use views and intelligent lookups in the Data Builder to combine, clean, and otherwise prepare data.

This topic contains the following sections:

For information about identifying the semantic usage of your entities and modeling them for consumption, see Modeling Data.

Combine, Filter, and Enrich Data with Views

You can combine, filter, enrich and otherwise prepare data in views.

You can write SQL or SQLScript (table function) code in a powerful SQL editor (see Creating an SQL View).
- To get started: In the side navigation area, select  (Data Builder), select a space if necessary, and select New SQL View to open the editor.
- SAP Datasphere supports:
  - A subset of the SQL syntax supported by SAP HANA Cloud (see SQL Reference).
  - The SQLScript syntax for table user-defined functions in SAP HANA Cloud (seeSQLScript Reference).
You can prepare your data in a graphical no code/low code environment (see Creating a Graphical View).
- To get started: In the side navigation area, select  (Data Builder), select a space if necessary, and select New Graphical View to open the editor.
- You can add and combine your sources by drag and drop (see Add a Source to a Graphical View, Create a Join in a Graphical View, and Create a Union in a Graphical View).
- You can refine, filter, and enrich your data in the diagram (see Reorder, Rename, and Exclude Columns in a Graphical View, Create a Calculated Column in a Graphical View, Filter Data in a Graphical View, and Aggregate Data in a Graphical View).
By default, views are virtual and must be run each time they are accessed. You can improve performance by persisting the view (see Persist Data in a Graphical or SQL View).

Transform Data (Including Delta Change Support) with Transformation Flows

Create a transformation flow to load data from one or more source repository tables, apply transformations, and output the result to a target table. You can load a full set of data or only delta changes from each source table (see Creating a Transformation Flow).

Combine Data via Match Rules in an Intelligent Lookup

You can join two entities even where there is no appropriate foreign key column or where its data is incomplete or unreliable, with an intelligent lookup. You can iteratively join two entities by defining rules to match records and then reviewing and processing the results (see Creating an Intelligent Lookup).

Browse the Catalog for Trusted Data Assets

You can browse the catalog to discover high-quality trusted data assets to use as sources in your views and other objects (see Searching for Data Products and Assets in the Catalog).

Visualize and Understand the Dependencies Between Objects

SAP Datasphere provides various ways to visualize and understand the dependencies between your entities and other objects:

You can visualize the objects that your object depends on (its lineage) and those that depend on it (its impacts) by opening its impact and lineage analysis (see Impact and Lineage Analysis).
You can visualize a set of entities and the associations between them by adding them to an entity-relationship model (see Creating an Entity-Relationship Model).
You can trace the source of a column in your graphical view and the transformations it has passed through (see Visualize Column and Input Parameter Lineages in a Graphical View).