can I delete document from azure cosmos db using sql query, without using any sdk.

Question

delete from c where c.id="someid"

Answer 1

Hi @Narayan, Deepak , welcome to Microsoft Q&A forum.

As rightly mentioned by @Sam Cogan , we cannot directly delete the documents using queries. However we can create a stored procedure as mentioned in the below link and then by executing the procedure we can delete the documents scoped to a partition key:

Stored Procedure for bulk deleting the documents

Then just execute the procedure as mentioned with parameters. Partition key was city in this container.

SELECT * FROM c WHERE c.city= 'mumbai'  

Please let us know if this helps or else we can discuss further on the same.

----------

If answer helps, you can mark it 'Accept Answer'

Answer 2

No, the SQL API does not provide facilities for delete, this must be done through the REST API, Storage Explorer etc.

Answer 3

You could use the following Gremlin query to remove given items. Notice that you are accessing NonSQL data as Graph, so that only a few fundamental properties are visible, i.e., partition key, unique id and label (label is always 'NativeVertex' here).

g.V().has('id', within(idsToDelete)).drop()