Is there a way to export my data from core SQL API to Gremlin API?

Nithish Reddy Minupuri 126 Reputation points
2021-09-22T15:19:22.5+00:00

I need to export my documents in core SQL API to Gremlin API , Is there a way to do it?

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,533 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
    2021-09-23T21:31:50.063+00:00

    Hi @Nithish Reddy Minupuri Thank you for posting your question on Microsoft Q&A.

    Apologies , I missed that Gremlin Part. This would be impossible because you would need to know how to build the relationships between nodes/edges. The gremlin API is not supported with ADF

    Regards,
    Oury


1 additional answer

Sort by: Most helpful
  1. Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
    2021-09-23T21:57:55.803+00:00

    Hi @Nithish Reddy Minupuri There is no ready-to-use tools for this since SQL API documents has a more complex data model than Gremlin API supports.

    If the document property content in SQL API is simple key to scalar value, and the customer knows what entities in SQL API they want to turn into vertices or edges in a Graph, then that is a good starting point.

    What is your language preference? .NET/java/ other?

    We can give guidance on how you can build vertex/edges from your source content using the appropriate SDKs from there.

    Regards,
    Oury

    0 comments No comments