Memgraph Writer

The node allows user to populate Memgraph with the data. There are three modes available:

• Script – active when there is no input table connected. User can create a Cypher script with injections of labels for nodes and relationships, and available server functions to extract data from the database. Schema is fetched with functions db.labels, db.relationshipTypes, dbms.functions. The output data will be automatically matched to Knime table compatible types if possible, otherwise JSON columns will be produced.
• Query from table - active if the table is connected, the user can select the string column that contains Cypher queries.
• Batch script - active if the table is connected, the user can provide a Cypher batch script with references to the input table columns as the parameters for the query. The capabilities are similar to Script mode.

Options

Script

Stop on query failure

if active the node will return an error and stop execution in case the query was not successfully executed. Otherwise node will produce an empty table and a warning message.

Script body

the text box, where use can put Cypher query with nodes, relationship, function and flow variables injections.

Query from table

Column with query

queries from the selected string column will be executed. Results and status will be returned as a JSON column.

Stop on query failure

if active the node will return an error and stop execution in case the query was not successfully executed. Otherwise node will produce an empty table and a warning message. All the transactions will be rolled back.

Use asynchronous query execution

if active all the queries will be running in asynchronous mode, otherwise there will be consequent execution starting from the top of the table.

Batch script

Use batch query

activates Batch query mode and deactivates Query from table mode.

Name for batch parameter

defines a batch variable name that can be used with UNWIND clause.

Batch Patterns

several examples with Cypher batch queries with wildcards, can be inserted to script body with double-click.

Column List

list of columns of input table, can be can be inserted to script body with double-click.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers