Steps to empty and copy datasets in Sanity.io discussed

Hi Team,Is there any way to empty dataset? Just have Dev dataset but remove all the content from it?

Just to give you more context,I am trying to copy my prod dataset to dev and want to empty dev dataset first before copying prod to dev to ensure there is no old data in dev.
I will be using

sanity dataset export production

to export and then import in dev but is there any way I can empty Dev dataset?

Hey User!

Easy way: Delete the dataset and then re-create it

Slightly harder way: Use the api to get every document and delete it. https://www.sanity.io/guides/bulk-deletion-using-sanity-cli << I would use a query like:
to select every document. The latter part of that query converts it to NDJSON so you don't run into API limits and delete a ton of stuff in a row

You can also get all documents with this empty filter:

*[]

.

Ooooo even fancier

Thank you both. This is really helpful. Just a dumb question I guess,If I delete the dataset and recreate it, as long as it is in my dataset limit, I wont get charge right?
I can re-create it with existing prod data, right? Do we have any document for this?

Also if I delete dataset, is there anything I should be careful or consider in terms of maybe data or affect on my website?

I'll have rd correct me if I'm wrong, 2 ways to do your second question:1. export prod database &gt; create new dev dataset &gt; import data from prod
2. Or, run copy, like the docs below, honestly my vote is this

https://www.sanity.io/docs/dataset#9d4339524663 ^^ dataset docs here

Aha yes, copy is good one. Looks easier than 1st approach.

I tried to copy dataset from Prod to staging but I got an error saying, my plan does not support this advance feature.

If that is the case then i assume, I only have one way to copy all data from prod to staging.
1. sanity dataset export prod
2. delete staging
3. sanity dataset import path-of-prod-backup staging

I have updated my above question as I found the issue in my query, instead of,staging.tar, I should have done staging.tar.gz

Yes, copying a dataset is an Enterprise feature. What you outlined is the correct way forward!