Uploaded Table Permissions
By default, uploaded tables are read-only — agents can query them but can't change the data. If you need agents to insert, update, or delete rows, an admin can enable modifications per table.
Default behavior
All uploaded tables start as read-only:
- Agents generate SELECT queries only
- INSERT, UPDATE, and DELETE operations are blocked
- This protects your data from accidental changes
No configuration is needed to get this behavior — it's the default for every new upload.
Enabling modifications
If you want agents to be able to change data in an uploaded table:
- Navigate to Data Connections → Uploaded Tables
- Select the table you want to modify
- Toggle Allow modifications on
When modifications are enabled, agents can:
- Add new rows to the table
- Update existing values in any column
- Delete rows that match query criteria
Modifications affect the platform's copy of your data only — your original CSV or XLSX file is never changed.
Visibility and modification combinations
Visibility and modification permissions are separate controls. Here's how they interact:
| Visibility | Modifications | Who can query | Who can modify |
|---|---|---|---|
| Private | Off | Only you | Nobody |
| Private | On | Only you | Only you |
| Org-wide | Off | All members | Nobody |
| Org-wide | On | All members | All members |
External databases are always read-only
The modification toggle only applies to uploaded CSV and XLSX tables. External database connections are always read-only — this is enforced at the code level and cannot be changed.
For details on why and how this safety guarantee works, see Read-Only Enforcement.
Related pages
- XLSX & CSV: Two Paths — How spreadsheets become queryable tables
- Read-Only Enforcement — Why external databases can never be modified