Is it possible to move data from one neo4j db to another db with neo4j data fabric feature of 4.x?

[danny_oberoi]

• neo4j version 4.0.8 community

Hi @dana.canzano & @david.allen,

Is it possible to move data from one neo4j db to another db with neo4j data fabric feature of 4.x?

Actually i want to use one db as staging db and another one is main db where daily/weekly load will be merged.

Danny

[danny_oberoi]

hi @dana.canzano, any first thought on this?

[sylvainroussy]

Hi!
I don't think it is possible today => not true, see second response.
I tried that from my fabric graph (neo4j enterprise 4.1.3):

CALL {
  USE fabric.sateliteGraph
  MATCH (n:Data)
  RETURN n AS n
}

CALL {
  USE fabric.mainGraph
  WITH n
  MERGE (n2:Data{id:n.id})
  RETURN n2
}
RETURN n2

And unfortunatly the result is:
Importing node values in remote subqueries is currently not supported

Then I tried to launch a query like it from my graph mainGraph, but the remote graph access is only possiblle from the fabric graph.

Maybe another way to do that? I'm interested.

[sylvainroussy]

But (from the fabric graph):

CALL {
  USE fabric.sateliteGraph
  MATCH (n:Data)
  RETURN n.id AS nodeId
}

CALL {
  USE fabric.mainGraph
  WITH nodeId
  MERGE (n2:Data{id:nodeId})
  RETURN n2
}
RETURN n2

Works well!
I understand nodes shouldn't passed to writing suqueries, only values.