LIST FILE - Kinetica Docs

Outputs detail about one or all KiFS files.

LIST FILE Syntax

<LIST|SHOW|DESC[RIBE]> FILE[S] <kifs path(s)>

Parameters

Name(s) of existing directories and/or files for which detail will be output, as a comma-separated list of single-quoted paths.

Path	Outcome
`’archive’`	Output detail of all files under the KiFS directory archive.
`‘data/q1.csv’,‘data/q2.csv’`	Output detail of q1.csv & q2.csv that reside under the data directory.

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

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

LIST FILES (Directory) Example

LIST FILES 'kdata'

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

LIST FILES (Specific Files) Example

LIST FILES 'kdata/products.csv', 'kdata/employee.parquet'