Import kuzu into kuzu?

[toman]

I'm new to Kuzu so maybe I'm missing something, but is there a way to take db1.kz and import it into db2.kz without some middle step of turning it in to DataFrames or similar? Collisions between primary keys would have to be handled of course, but being able to import a Kuzu file, or export a subgraph directly to a Kuzu file seems like it would be quite handy. Thanks!

[prrao87]

Hi @toman, the output of a Kuzu query is a QueryResult. In Python, these are iterables and need to be consumed to produce some intermediate representation (either in Python, or in DataFrames) to materialize the result before they can be used downstream. The underlying connection object is tied to the database instance that had the original data, i.e., db1.kz. To get it into db2.kz, you cannot pass the contents of a query result from one connection object into another database entirely without persisting to some intermediate file. Hope that makes sense.

The easiest way for you to get data from one graph into another is to a) use the EXPORT DATABASE command and then re-import in a single line of code to a new db, or b) use COPY TO and persist the nodes/rels of the relevant subgraph into a file format like Parquet, and handle the ETL to bring the data into a new db.

Hope that makes sense.