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.

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

Provide the Node with a Label of Transaction which can be selected from the list informed by the schema.

To add a Property to your Node, select the Node to bring up the properties tab. Then select + New Property and provide a key of amount (informed by the schema), a template of {amount} (informed by the DB source data) and type of int. Select the tick to confirm and you will see the number of properties your node has.

To create an Edge, add another Node using vendorId and provide a label of Organisation. Now draw a connection between the two Nodes. The Edge will be created and by referencing the schema, it will automatically be populated with the value of VENDOR.

Additional Properties can be added to the Edges as well as the Nodes in the same way as step 3.