Table | Description |
---|---|
Vertices | Each row represents a vertex of the graph. |
Edges | Each row represents an edge of the graph. |
Sources | [Optional] Specifies vertices to use as sources. This table is a subset of the Vertices table. If you specify this table, the function uses only the nodes in this table as sources. |
Vertices Schema
Column | Data Type | Description |
---|---|---|
vertex_key_column | Any allowed in PARTITION BY clause | [Column appears once for each specified vertex_key_column.] All or part of unique vertex key. Cannot be NULL. |
accumulate_column | Any | [Column appears once for each specified accumulate_column.] Column to copy to community Vertices table. |
Edges Schema
Column | Data Type | Description |
---|---|---|
source_vertex_key_column | Any allowed in PARTITION BY clause | Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL. |
target_key_column | Same as source_vertex_key_column | Column appears once for each specified target_key_column.] All or part of key that identifies target vertex of edge. Must be a vertex_key_column in Vertices table. Can be NULL. |
edge_weight | SMALLINT, INTEGER, or NUMERIC | [Required only for weighted graph.] Edge weight, a positive value. Can be NULL. |
Sources Schema
Column | Data Type | Description |
---|---|---|
source_vertex_key_column | Same as corresponding vertex_key_column in Vertices table | Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL. |