# PIPELINES\_FILES

This view stores information about files that have been extracted from a file system-like data source, such as Amazon S3. Each row represents a single file.

## information\_schema.PIPELINES\_FILES Schema

| Column Name     | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `DATABASE_NAME` | The name of the database associated with the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| `PIPELINE_NAME` | The name of the pipeline associated with the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| `SOURCE_TYPE`   | The name of the pipeline’s data source, such as`S3`.                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| `FILE_NAME`     | The name of the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| `FILE_SIZE`     | The size of the file in bytes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| `FILE_STATE`    | Shows the state of the file, which is one of the following values:<ul> <li><code>Unloaded</code>: The pipeline has not yet loaded the data in the file into any tables.</li> <li><code>Loaded</code>: The pipeline has successfully processed the file. The data in the file has been loaded into one or more tables.</li> <li><code>Skipped</code>: The pipeline encountered an error while processing the file; the file is skipped and no data in the file has been loaded into any tables.</li> </ul> |

> **📝 Note**: Monitor the `information_schema.pipelines_files` table. It stores data for the duration of the pipeline’s lifetime, resulting in a large number of files referenced in the table. If the data in this table is not required, you can either drop a file record from the table or [clear all the file records](https://docs.singlestore.com/db/v9.1/load-data/about-singlestore-pipelines/pipeline-troubleshooting/troubleshoot-pipeline-performance-and-memory-usage/#section-idm234440120576006.md) from it.

***

Modified at: August 1, 2024

Source: [/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-files/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-files/)

(An index of the documentation is available at /llms.txt)