Can a delete or update query be run against a datasphere table?

[robert_schmidt01]

I want to update some data in some tables in Datasphere. Can I write a simply query and execute it to accomplish the modifications?

[michael_eaton3 · Accepted solution]

Yes, if you've created a database user and the table is in the open schema, but no if the table is in the space schema.

You could use a dataflow to modify the table's content.

[glamoureux46 · Accepted solution]

Hi. I have the same problem. What do you mean by "Open schema" ?

[robert_schmidt01]

Thanks, this is the only way that I could find a way. I was hoping that we could simply run an update query.