Skip to main content
The cockroach nodelocal upload command uploads a file to the external IO directory on a node’s (the gateway node, by default) local file system. This command takes in a source file to upload and a destination filename. It will then use a SQL connection to upload the file to the node’s local file system, at externalIODir/destination/filename.
The source file is only uploaded to one node, not all of the nodes.
CockroachDB now supports uploading files to a user-scoped file storage using a SQL connection. We recommend using userfile instead of nodelocal, as it is user-scoped and more secure.

​
Required privileges

Only members of the admin role can run cockroach nodelocal upload. By default, the root user belongs to the admin role.

​
Considerations

The --external-io flag on the node you’re uploading to cannot be set to disabled.

​
Synopsis

Upload a file:
View help:

​
Flags

​
Examples

​
Upload a file

To upload a file to the default node (i.e., the gateway node):
Then, you can use the file to IMPORT or IMPORT INTO data.

​
Upload a file to a specific node

To upload a file to a specific node (e.g., node 2), use the --host flag:
Or, use the --url flag:
Then, you can use the file to IMPORT or IMPORT INTO data.

​
See also