---
title: "sql_write"
description: "Needs `files:write`."
---

| Tool | Kind | Purpose |
| :-- | :-- | :-- |
| `sql_write` | write | Needs `files:write`. `CREATE VIEW` makes a view each member reads with their own access, `CREATE TABLE AS` makes a snapshot only you read, over `sources` (the ids of the files it may read; every file you can read when omitted), hidden while a source is in the trash and dropped when a source is purged, and `DROP VIEW` or `DROP TABLE` removes one of your own. |