hi all I want a script that copies the database & data from one environment to a demo environment The snapshot & data need to be the same except for one column that needs to be random values or any arbitrary unique values How do you do that using prisma client js or snaplet? prisma connector is sqlite thanks

Do you mean data seeding from one database to another right?

Yes but the seed needs to be the exact state of the database at the point in time, like snaplet snapshot. I believe snaplet/copycat can set fake deterministic values for a column

in my experience I build my ETL tool to keep snapshot

that’s very nice, is there an example for prisma SQLite ?

I'm apologize that I cannot share because its company tools