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

# LIST FILE

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

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

Outputs detail about one or all
[KiFS files](/content/tools/kifs_api#kifs-file).

```sql title="LIST FILE Syntax" theme={null}
<LIST|SHOW|DESC[RIBE]> FILE[S] <kifs path(s)>
```

## Parameters

<AccordionGroup>
  <Accordion title="<kifs path(s)>" id="<kifs-path-s->" defaultOpen>
    Name(s) of existing *directories* and/or *files* for which detail will be output, as a
    comma-separated list of single-quoted paths.

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

        <tbody>
          <tr>
            <td><code>'archive'</code></td>
            <td>Output detail of all *files* under the *KiFS directory* <Badge color="gray">archive</Badge>.</td>
          </tr>

          <tr>
            <td><code>'data/q1.csv','data/q2.csv'</code></td>
            <td>Output detail of <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>
</AccordionGroup>

## Response

The response to `LIST FILE` is a four-column result set:

| Output Column | Description |
| - | - |
| `FILE_NAME` | Name of the *file* |
| `SIZE` | Size of the file in bytes |
| `CREATED_BY` | User ID of the user who created the *file* |
| `CREATION_TIME` | Date/time at which the *file* was created |

## Examples

To output a listing of all *files* under the *KiFS directory*, `kdata`:

```sql LIST FILES (Directory) Example theme={null}
LIST FILES 'kdata'
```

To output a listing of specific *files* under the *KiFS directory*, `kdata`:

```sql LIST FILES (Specific Files) Example theme={null}
LIST FILES 'kdata/products.csv', 'kdata/employee.parquet'
```


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