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

Outputs detail about one or all
[KiFS files](https://docs.kinetica.com/content/tools/kifs_api.md#kifs-file).

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

## Parameters

> [accordion] \<kifs path(s)>
>
> Name(s) of existing *directories* and/or *files* for which detail will be output, as a
> comma-separated list of single-quoted paths.
>
> <table>
>   <thead>
>     <tr>
>       <th>Path</th>
>       <th>Outcome</th>
>     </tr>
>   </thead>
>
>   <tbody>
>     <tr>
>       <td>`'archive'`</td>
>       <td>Output detail of all *files* under the *KiFS directory* archive.</td>
>     </tr>
>
>     <tr>
>       <td>`'data/q1.csv','data/q2.csv'`</td>
>       <td>Output detail of q1.csv & q2.csv that reside under the data directory.</td>
>     </tr>
>   </tbody>
> </table>

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