I recently created a new database and created some queries. However when I'm trying to change one of the queries, I get the following error message:

Performed changes in the query is not allowed due to following reason(s):

Column 'totaltransactions' is used in the Query table 'Cohorts revenue'

I think this might be due to the DB settings that's not allowing me to make changes if it impacts another child table. If so, how can I change the DB settings so that I can make those changes (even if they impact other queries?)

Thanks for your help.

Virginie