Skip to main content
Uploads file(s) local to the database client into KiFS, within the given directory.
This command is only available through KiSQL or database clients configured with the Kinetica JDBC driver.
UPLOAD FILE Syntax

​
Parameters

<file path(s)>

Local path(s) of the file(s) to upload to KiFS, as a comma-separated list of single-quoted file paths; wildcards (*) can be used to specify a group of files.
File PathOutcome
’archive/*.csv’Upload all files under the archive directory with a csv extension
’data/q1.csv’,‘data/q2.csv’Upload q1.csv & q2.csv that reside under the data directory

<kifs path>

Path in KiFS; this can be either the name of a directory or a directory followed by virtual subdirectories separated by / characters.For example, uploading a file named 2021.q1.csv to:
  • 'data' - will upload it to the data directory and make it available as data/2021.q1.csv
  • 'data/sales/Q1' - will upload it to the data directory and make it available as data/sales/Q1/2021.q1.csv
Only the directory specified within this path must exist for the upload to succeed. Any virtual subdirectories added to this path do not need to exist before uploading.

​
Examples

To upload a file to a directory, kdata:
UPLOAD FILE Example
To upload several files to a directory, kdata:
UPLOAD FILES Example