Data Cleaning in Mode
I am using a public dataset in Mode to practice data cleaning in SQL.
The dataset contains entries with variant spelling that need to be standardized. It seems like the UPDATE command is the way to go, but when I attempt to execute the query, I get the following error:
cannot execute UPDATE in a read-only transaction
Is there a workaround for this or anything else you might recommend?
Hi Will - thanks for writing in and letting us know
Aside from being able to upload new data or delete tables within your own schema, the Mode Public Warehouse is read-only. Therefore, you won't be able to execute an UPDATE command.
My suggestion would be to create your own database using Google Cloud or AWS and upload your practice datasets there so that you'll have write access.
Hope that helps - please do reach out to our success team via in-product chat or firstname.lastname@example.org if we can be of further assistance. Thanks!Reply