Execute Cypher Recipe

The Execute Cypher recipe allows you to run a query against a graph database and save the tabular results to a dataset.

You can target a graph published by Visual Graph to a Dataiku Folder or, for Neo4j, an unmanaged database selected directly in the recipe settings. See graph database recipe settings.

This is useful for feature engineering, generating analytical reports, or exporting subsets of your graph.

Input / Output

Input

• Graph folder (Optional): Dataiku Folder that contains your materialized graph database. Leave it empty to query an unmanaged Neo4j database directly.

Output

• Output dataset: Output dataset to store the results of the executed query.

Settings

Cypher query

Enter the Cypher query to be executed.

Note

Execute Cypher opens the selected graph database in read-only mode. Queries that require writes will fail.