cockroach userfile get fetches the files stored in the which match the provided pattern, using a SQL connection. If no pattern is provided, all files in the specified (or default, if unspecified) user-scoped file storage will be fetched.
Required privileges
The user must haveCONNECT on the target database.
A user can only fetch 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 and users explicitly granted access.
If this is your first interaction with user-scoped file storage, you may see an error indicating that you need
CREATE privileges on the database. You must first or run a to userfile before attempting to get a file.Synopsis
Fetch a file:Flags
Examples
Get a specific file
To get the file named test-data.csv from the default user-scoped storage location for the current user:Get a file saved to an explicit local file name
To get a file named test-data.csv from a local directory:Get a file from a non-default userfile URI
If you (e.g.,userfile://testdb.public.uploads), use the same URI to fetch it: