Warnings During Property Graph Creation

When creating a property graph, the property graph wizard validates the designed graph and reports any validation errors or warnings.

It is important to note that you can still create a property graph by ignoring the warnings that are generated at the time of creating the graph. However, the graph cannot be loaded into memory.

The following table lists the warning messages that are generated during property graph creation.

Warning Message Reason
Vertex table <table_name> has composite key (<composite_key>) which will prevent this graph from being loaded into memory.

See the documentation for more details

Vertex table cannot have a composite key. Note that this applies only for PGQL property graphs.
Key column <column_name> of vertex table <table_name> has a data type which will prevent this graph from being loaded into memory.

See the documentation for details and a list of supported datatypes

Vertex table key must be one of the following types:

VARCHAR, VARCHAR2, NVARCHAR2, CHAR, NCHAR, NUMBER

Key column <column_name> of edge table <table_name> has a data type which will prevent this graph from being loaded into memory.

See the documentation for details and a list of supported datatypes

Edge table key must be one of the following types:

VARCHAR, VARCHAR2, NVARCHAR2, CHAR, NCHAR, NUMBER, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP, TIMESTAMP_WITH_LOCAL_TIME_ZONE, TIMESTAMP_WITH_TIME_ZONE

Column <column_name> of table <table_name> will prevent this graph from being loaded into memory.

See the documentation for details and a list of supported datatypes

Vertex or edge table columns must be one of the following types:

VARCHAR, VARCHAR2, NVARCHAR2, CHAR, NCHAR, NUMBER, BINARY_FLOAT, BINARY_DOUBLE, CLOB, DATE, TIMESTAMP, TIMESTAMP_WITH_LOCAL_TIME_ZONE, TIMESTAMP_WITH_TIME_ZONE

<Vertex/Edge> table key column(s) <column_names> in table (<table_name>) does not have an index. Index is missing in the underlying database table columns for one or more of the following - vertex key, edge key, source, and destination key columns.

Graph Studio recommends indexing the key columns to optimize graph query traversals and ensuring faster retrieval of nodes and edges.

Click Add Index on the warning message to add index for the specific column.