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

  • 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

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

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.

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.