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
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
How do I migrate Cassandra data to DSE Graph?
The graph dB could be in the same database instance as the existing tables..
@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!
Excellent! Thanks @Erick Ramirez Ill take a read through, but looks like exactly what we are looking for
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.
7 People are following this question.
