cockroach userfile delete

The cockroach userfile delete deletes the files stored in the which match the , using a SQL connection. If the pattern '*' is passed, all files in the specified (or default, if unspecified) user-scoped file storage will be deleted. Deletions are not atomic, and all deletions prior to the first failure will occur.

Required privileges

The user must have the CREATE on the target database. CockroachDB will proactively grant the user GRANT, SELECT, INSERT, DROP, DELETE on the metadata and file tables. A user can only delete files from their own user-scoped storage, which is accessed through the used during the upload. CockroachDB will revoke all access from every other user in the cluster except users in the admin role. Users in the admin role can delete from any user’s storage.

Synopsis

Delete a file:

$ cockroach userfile delete <file | dir> [flags]

View help:

$ cockroach userfile delete --help

Flags

Flag	Description
`--cert-principal-map`	A comma-separated list of `<cert-principal:<db-principal` mappings. This allows mapping the principal in a cert to a DB principal such as `node` or `root` or any SQL user. This is intended for use in situations where the certificate management system places restrictions on the `Subject.CommonName` or `SubjectAlternateName` fields in the certificate (e.g., disallowing a `CommonName` like `node` or `root`). If multiple mappings are provided for the same `<cert-principal`, the last one specified in the list takes precedence. A principal not specified in the map is passed through as-is via the identity function. A cert is allowed to authenticate a DB principal if the DB principal name is contained in the mapped `CommonName` or DNS-type `SubjectAlternateName` fields.
`--certs-dir`	The path to the containing the CA and client certificates and client key. Env Variable: `COCKROACH_CERTS_DIR` Default: `${HOME}/.cockroach-certs/`
`--echo-sql`	Reveal the SQL statements sent implicitly by the command-line utility.
`--url`	A to use instead of the other arguments. Env Variable: `COCKROACH_URL` Default: no URL
`--user` `-u`	The that will own the client session. Env Variable: `COCKROACH_USER` Default: `root`

Examples

Delete all files in the default storage

To delete all files in the directory, pass the '*' pattern:

$ cockroach userfile delete '*' --certs-dir=certs

deleted userfile://defaultdb.public.userfiles_root/test-data-2.csv
deleted userfile://defaultdb.public.userfiles_root/test-data.csv
deleted userfile://defaultdb.public.userfiles_root/test-upload/test-data.csv

Note that because a fully qualified userfile URI was not specified, files in the default user-scoped storage (userfile://defaultdb.public.userfiles_$user/) were deleted.

Delete a specific file

To delete a specific file, include the file destination in the command:

$ cockroach userfile delete test-data.csv --certs-dir=certs

deleted userfile://defaultdb.public.userfiles_root/test-data.csv

Delete files that match the provided pattern

To delete all files that match a pattern, use *:

$ cockroach userfile delete '*.csv' --certs-dir=certs

deleted userfile://defaultdb.public.userfiles_root/test-data-2.csv
deleted userfile://defaultdb.public.userfiles_root/test-data.csv

Delete files from a non-default userfile URI

If you (e.g., userfile://testdb.public.uploads):

cockroach userfile upload /Users/maxroach/Desktop/test-data.csv userfile://testdb.public.uploads/test-data.csv

Use the same URI to delete it:

cockroach userfile delete userfile://testdb.public.uploads

​Required privileges

​Synopsis

​Flags

​Examples

​Delete all files in the default storage

​Delete a specific file

​Delete files that match the provided pattern

​Delete files from a non-default userfile URI

​See also