# PIPELINES\_ICEBERG\_FILES

> **📝 Note**: This is a Preview feature. The table schema is subject to change.

This view stores information about Iceberg data files ingested using pipelines with [`FORMAT ICEBERG`](https://docs.singlestore.com/db/v9.1/load-data/data-sources/iceberg-ingest.md).

Files listed in this view include current and previously processed snapshots.

This view is a subset of the [PIPELINES\_FILES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-files.md) information schema view that contains Iceberg-specific file status.

| 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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| `FILE_ID`            | Internal metadata file ID.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| `FILE_NAME`          | Storage location of the file as specified in the Iceberg metadata.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| `FILE_STATE`         | Shows the state of the file. Possible values:<ul> <li><code>Data Unloaded</code> This file has not been ingested yet.</li> <li><code>Data Loaded</code> This file has been ingested.</li> <li><code>Pending Data Removal</code> This file has been removed from the source Iceberg snapshot, but has not been removed from the destination SingleStore table.</li> <li><code>Data Removed</code> This file has been removed from the source Iceberg snapshot and the destination SingleStore table.</li> <li><code>Positional Deletes Unloaded</code> This file is a positional delete file that has not been applied to the destination SingleStore table yet.</li> <li><code>Positional Deletes Loaded</code> This file is a positional delete file that has been applied to the destination SingleStore table.</li> <li><code>Equality Deletes Unloaded</code> This file is an equality delete file that has not been applied to the destination SingleStore table yet.</li> <li><code>Equality Deletes Loaded</code> This file is an equality delete file that has been applied to the destination SingleStore table.</li> <li><code>Pending Deletes Removal</code> This is a delete file that has been removed from the source Iceberg snapshot, but has not been removed from the destination SingleStore table yet.</li> <li><code>Deletes Removed</code> This is a delete file that has been removed from the source Iceberg snapshot and the destination SingleStore table.</li> </ul> |
| `SNAPSHOT_ID`        | The snapshot id associated with the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| `SNAPSHOT_TIMESTAMP` | The snapshot timestamp; the time that the snapshot was generated.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |

***

Modified at: March 5, 2026

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

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