question

nithishreddyminupuri-8171 avatar image
0 Votes"
nithishreddyminupuri-8171 asked OuryBa-MSFT answered

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

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

azure-cosmos-db
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

Hi @nithishreddyminupuri-8171 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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Oury ,
I have asked about moving my data from SQL API to Gremlin. ADF doesnt support Gremllin.

0 Votes 0 ·
OuryBa-MSFT avatar image OuryBa-MSFT nithishreddyminupuri-8171 ·

Hi @nithishreddyminupuri-8171 Please see my answer above. Let me know if you need any additional queries. I will be more than happy to help

Regards,
Oury

1 Vote 1 ·
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered

Hi @nithishreddyminupuri-8171 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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.