Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

burke.damo_187866 avatar image
burke.damo_187866 asked ·

How do I migrate Cassandra data to DSE Graph?

Hi. We are building a dse graph database and wish to seed the graph using some existing Cassandra tables. The dse graph loader tool looks really slick, but is there another option for importing this data? I am still ramping up on dse graph and understanding it’s relationship with its Cassandra backend.. Thanks

dsegraph
1 comment
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

The graph dB could be in the same database instance as the existing tables..

0 Likes 0 ·
Erick Ramirez avatar image
Erick Ramirez answered ·

@burke.damo_187866 In DSE 6.8, the new version of DataStax Graph allows you to read and write graph data using CQL, Gremlin or both.

If you haven't seen it already, there is new Graph API that allows you to do CQL conversion to Graph -- i.e. convert CQL keyspace and tables to a graph that can be queried with Gremlin. The DataStax Graph: CQL conversion to Graph page has a step-by-step example of how to convert a CQL table into DataStax Graph with simple ALTER TABLE commands that look like these:

ALTER TABLE ... WITH VERTEX LABEL ...
ALTER TABLE ... WITH EDGE LABEL ... FROM ... TO ...

Let me know if you have any questions and I'll get you in touch with one of the Graph engineers. Cheers!

2 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Excellent! Thanks @Erick Ramirez Ill take a read through, but looks like exactly what we are looking for

0 Likes 0 ·

Not a problem. Cheers!

0 Likes 0 ·
eddy.wong_186388 avatar image
eddy.wong_186388 answered ·

With 6.8, from a modeling perspective, you could use your existing tables to store your "vertices" and add new tables which would be your "edges". The other method, as you mentioned, is the DSBulk loader, which loads data from a CSV format. You can load vertices and/or edges with DSBulk.

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.