Query and Visualize SQL Property Graphs

You can query and visualize SQL property graphs in Graph Explorer.

1. Expand SQL Property Graphs in the left navigation pane.

2. Expand the desired schema to view the list of SQL property graphs to which you have access.

3. Right click on a specific graph and click Generate Basic Query in the context menu.

   The basic SQL graph query is auto-generated in the query editor for the selected graph. You can edit the query, if required. Alternatively, you can directly enter the graph query in the query editor.

   Also, note the following:

   • The name of the graph must be provided in the SQL graph query.

     To copy it, right click on the graph and select Copy Graph Name from the context menu.

   • To visualize GRAPH_TABLE query results in Graph Explorer, the query must return the vertex ID, the edge ID, or both.

4. Select SQL driver in the query actions panel at the top of the query editor.

5. Click Visualize Graph.

   The following example shows the visualization of a GRAPH_TABLE query on a SQL property graph. Note that the COLUMNS clause uses the VERTEX_ID and EDGE_ID functions.

   

   Description of the illustration explorer_query_sql_pg.png