Hello, we use FireStore for the database for our product. We were hoping to be able to use Retool to query it but with READ ONLY privileges, as we don't want to accidentally modify our data unknowingly via Retool. Is it possible to do this? I'm not seeing it in the settings.
Thanks.
Hello!
Great question. I do believe the permissions can be configured on the FireStore side:
https://firebase.google.com/docs/database/security
https://firebase.google.com/docs/firestore/security/rules-conditions
When it comes to Retool, you could only create queries that read data and restrict edit access if you're on a business plan.
Let me know what you think and if you have any further questions!
John