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

<a id="sql-kifs-download-file" />

Downloads file(s) from [KiFS](/content/tools/kifs) into a local directory.

<Info>
  This command is only available through
  [KiSQL](/content/tools/kisql) or database clients configured with
  the [Kinetica JDBC driver](/content/connectors/sql_guide#odbc-jdbc).
</Info>

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

## Parameters

<AccordionGroup>
  <Accordion title="FILE[S]" id="files" defaultOpen>
    Optional keyword for clarity.
  </Accordion>

  <Accordion title="<kifs file path(s)>" id="<kifs-file-path-s->" defaultOpen>
    *KiFS file(s)* to download to the local file system, as a comma-separated list of single-quoted
    file paths.

    <div>
      <table class="table w-full [&_td]:min-w-[150px] [&_th]:text-left [&_td[data-numeric]]:tabular-nums">
        <thead>
          <tr>
            <th>File Path</th>
            <th>Outcome</th>
          </tr>
        </thead>

        <tbody>
          <tr>
            <td><code>'archive/products.csv'</code></td>
            <td>Download <Badge color="gray">archive/products.csv</Badge></td>
          </tr>

          <tr>
            <td><code>'data/q1.csv','data/q2.csv'</code></td>
            <td>Download <Badge color="gray">q1.csv</Badge> & <Badge color="gray">q2.csv</Badge> that reside under the <Badge color="gray">data</Badge> directory</td>
          </tr>
        </tbody>
      </table>
    </div>
  </Accordion>

  <Accordion title="<local directory>" id="<local-directory>" defaultOpen>
    Local directory path into which files will be downloaded.
  </Accordion>
</AccordionGroup>

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