Data Cleaning in Mode

Hi all,

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?



1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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 if we can be of further assistance. Thanks!

    Reply Like
Like Follow
  • Status Answered
  • 9 mths agoLast active
  • 1Replies
  • 296Views
  • 2 Following

Create A New Discussion

Share your thoughts