> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# UPLOAD FILE

Uploads file(s) local to the database client into
[KiFS](https://docs.kinetica.com/content/tools/kifs.md), within the given
[directory](https://docs.kinetica.com/content/tools/kifs_api.md#kifs-directory).

> [!NOTE]
>
> This command is only available through
> [KiSQL](https://docs.kinetica.com/content/tools/kisql.md) or database clients configured with
> the [Kinetica JDBC driver](https://docs.kinetica.com/content/connectors/sql_guide.md#jdbc).

```sql title="UPLOAD FILE Syntax" theme={null}
UPLOAD FILE[S] <file path(s)>
INTO '<kifs path>'
```

## Parameters

> [accordion] \<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.
>
> <table>
>   <thead>
>     <tr>
>       <th>File Path</th>
>       <th>Outcome</th>
>     </tr>
>   </thead>
>
>   <tbody>
>     <tr>
>       <td>`'archive/*.csv'`</td>
>       <td>Upload all files under the archive directory with a csv extension</td>
>     </tr>
>
>     <tr>
>       <td>`'data/q1.csv','data/q2.csv'`</td>
>       <td>Upload q1.csv & q2.csv that reside under the data directory</td>
>     </tr>
>   </tbody>
> </table>

> [accordion] \<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`
>
> > [!NOTE]
> >
> > 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`:

```sql UPLOAD FILE Example theme={null}
UPLOAD FILE '../data/products.csv'
INTO 'kdata'
```

To upload several files to a *directory*, `kdata`:

```sql UPLOAD FILES Example theme={null}
UPLOAD FILES '../data/p*.ssv', '../data/employee.*'
INTO 'kdata'
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.