Create Node, Properties, and Edges

To create a model from the source data, a SQL query is required to return a sample of the data to be transformed. Running a simple query like the one shown below, will return the results of the query as well as the draggable blocks to create your model with. NB When creating a model for use in production remove any limit in the query otherwise your transformation will only be for the limited data.

Open the Input Blocks section and drag a block into the designer. Once placed, select Node.

Provide the Node with a Type of gbo:Transaction which can be selected from the list informed by the ontology.

To add a Property to your Node, drag time from the source and select Property, and provide it with a DataType of xsd:dataTime.

To create a predicate, draw a connection between the Node and the Property. The Edge will be created and by referencing the ontology, it will be automatically populated with the value gbo:timeStamp.

Creating a predicate between two nodes is done in the same way as with creating one with a property.