| title | summary | toc |
|---|---|---|
cockroach userfile delete |
The cockroach userfile delete command deletes files stored in user-scoped file storage. |
true |
New in v20.2: The cockroach userfile delete command deletes the files stored in the user-scoped file storage which match the provided pattern, 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.
The user must have the CREATE privilege 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 userfile URI 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.
Delete a file:
$ cockroach userfile delete <file | dir> [flags]View help:
$ cockroach userfile delete --helpFlag | 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 certificate directory 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 connection URL to use instead of the other arguments.
Env Variable: COCKROACH_URL
Default: no URL
--user-u | The SQL user that will own the client session.
Env Variable: COCKROACH_USER
Default: root
To delete all files in the directory, pass the '*' pattern:
{% include copy-clipboard.html %}
$ cockroach userfile delete '*' --certs-dir=certsdeleted 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.
To delete a specific file, include the file destination in the command:
{% include copy-clipboard.html %}
$ cockroach userfile delete test-data.csv --certs-dir=certsdeleted userfile://defaultdb.public.userfiles_root/test-data.csv
To delete all files that match a pattern, use *:
{% include copy-clipboard.html %}
$ cockroach userfile delete '*.csv' --certs-dir=certsdeleted userfile://defaultdb.public.userfiles_root/test-data-2.csv
deleted userfile://defaultdb.public.userfiles_root/test-data.csv
If you uploaded a file to a non-default userfile URI (e.g., userfile://testdb.public.uploads):
{% include copy-clipboard.html %}
cockroach userfile upload /Users/maxroach/Desktop/test-data.csv userfile://testdb.public.uploads/test-data.csvUse the same URI to delete it:
{% include copy-clipboard.html %}
cockroach userfile delete userfile://testdb.public.uploads