Query format

When writing queries to configure the import agent, you should make sure they adhere to the following rules:

• for entity queries:

  • the number of output columns should equal the number of configured attributes plus two

  • the first output column should have a textual type and represents the entity's id

  • the second output column should have a textual type and represents the entity's name

  • the following output columns should type-match with the entity type's configured attributes (so order of configured attributes is important)

• for relationship queries:

  • the number of output columns should equal the number of configured attributes plus two

  • the first output column should have a textual type and represents the source entity's id

  • the second output column should have a textual type and represents the target entity's id

  • the following output columns should type-match with the relationship type's configured attributes (so order of configured attributes is important)

• the import agent will not generate attribute assignments for output columns that have a NULL value