Enable Update Queries

We have constructed an update query using Query Editor as below:

update "public"."Accounts"
set "scheduleID" = {{ scheduleID }}, "error" = null
where "public"."Accounts"."embassyEmail" = {{embassyEmail}} and "public"."Accounts"."country" = {{ country }}
returning *;

And to enable update in Metabase we have added readOnlyMode=ignore to JDBC connection string options.
When we execute previous query, it returns updated value and seems everything is fine but in database it is unchanged and if we select it again we couldn't see our changes.

What is the problem and how we can fix it?

Metabase does not allow updates yet. We’re planning some features for the near future about this

1 Like

Thank you very much for providing this news.