Import data from BigQuery to Neo4j Aura DS: Missing Key Field

Neo4j Graph Platform Import / Export
1

Hello,

I am trying to import data from BigQuery to Neo4j Aura DS but it keeps failing. Here is the GCP dataflow log.

No newer entries found matching current filter.
2023-12-05 22:36:03.574 CST
com.google.cloud.teleport.v2.common.UncaughtExceptionLogger - The template launch failed.
java.lang.RuntimeException: Errors found validating job specification: Missing key field in node: Email

at com.google.cloud.teleport.v2.neo4j.templates.GoogleCloudToNeo4j.processValidations(GoogleCloudToNeo4j.java:210)
at com.google.cloud.teleport.v2.neo4j.templates.GoogleCloudToNeo4j.<init>(GoogleCloudToNeo4j.java:154)
at com.google.cloud.teleport.v2.neo4j.templates.GoogleCloudToNeo4j.main(GoogleCloudToNeo4j.java:198)

Key is present.

image
image1307×1223 70.2 KB

Any is help is greatly appreciated. Thank you!

2

@amishra You need to include the keys within the properties for a given node. For example,

"properties": {
        "keys": [
            {
                "UserID": "UserID"
            }
        ]
    }
3

Awesome! That worked. Thank you so much.

1 Like