> ## 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.

# DOWNLOAD FILE

Downloads file(s) from [KiFS](https://docs.kinetica.com/content/tools/kifs.md) into a local 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="DOWNLOAD FILE Syntax" theme={null}
DOWNLOAD [FILE[S]] <kifs file path(s)>
INTO '<local directory>'
```

## Parameters

> [accordion] FILE\[S]
>
> Optional keyword for clarity.

> [accordion] \<kifs file path(s)>
>
> *KiFS file(s)* to download to the local file system, as a comma-separated list of single-quoted
> file paths.
>
> <table>
>   <thead>
>     <tr>
>       <th>File Path</th>
>       <th>Outcome</th>
>     </tr>
>   </thead>
>
>   <tbody>
>     <tr>
>       <td>`'archive/products.csv'`</td>
>       <td>Download archive/products.csv</td>
>     </tr>
>
>     <tr>
>       <td>`'data/q1.csv','data/q2.csv'`</td>
>       <td>Download q1.csv & q2.csv that reside under the data directory</td>
>     </tr>
>   </tbody>
> </table>

> [accordion] \<local directory>
>
> Local directory path into which files will be downloaded.

## Examples

To download a *KiFS file* to a local directory, `/tmp`:

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

To download several *KiFS files* to a local directory, `/tmp`:

```sql DOWNLOAD FILES Example theme={null}
DOWNLOAD FILES 'kdata/products.ssv', 'kdata/employee.parquet'
INTO '/tmp'
```


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