I am wondering if it is safe to use an admin user to connect to a database.
For instance, I connect Metabase to my postgres database using the admin user.
It seems that I cannot create / drop table through the sql interface of Metabase though. Is it the expected behaviour ?
It also seems that create index is not working, even though it takes several minutes to complete (what is it doing ?)
Is there some documentation discussing this topic ?
What kind of user do you usually use to connect Metabase to your database ?
You can’t manipulate data through the Metabase SQL interface. We use read-only connections to prevent tampering, etc.