Dremio Users may try to delete or edit database.
dremio mcp server can edit data in Dremio commercial free versions tables?
i mean if dremio mcp generate and run UPDATE, or DELETE query then it will directly run on Dremio commercial free versions tables?
if its possible how to prevent that?
please help
@ganbaatar I tried to use Clause (MCP server) and drop a table and I got back saying “it can only do READ” operations, see below
Can you please drop the table called log_synth_rand_tab1
Edit
I cannot drop tables in the Dremio cluster. The tools available to me only allow SELECT queries - I'm not permitted to run DML (Data Manipulation Language) statements like DROP TABLE for security reasons.
If you need to drop the table log_synth_rand_tab1, you'll need to:
Use the Dremio web interface directly
Use a database client with the appropriate permissions
Ask a database administrator with DROP privileges to remove it