# FileIndexFiles: Big Data JSON File Index Files The data files described in the index of each table: size, moment, record count and whether the description still fits the file. ## Documentation The data files described in the index of each table: size, moment, record count and whether the description still fits the file. - Catalog: `BigData` - Schema: `System` - Label: File Index Files This is a read-only view. The Big Data JSON API may not support changing the data or the Invantive UniversalSQL driver for Big Data JSON does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Big Data JSON API. ## View Columns The columns of the view `FileIndexFiles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `bloom_filters_dropped_for` | `varchar2(4000)` | Bloom Filters Dropped For | ☐ | Columns whose Bloom filter was dropped to stay inside the size budget, comma-separated. | | `column_count` | `number` | Column Count | ☑ | Number of columns described for the data file. | | `data_size_bytes` | `int64` | Data Size (bytes) | ☑ | Bytes of records the data file yielded when it was described: for a compressed file what it holds rather than what it takes on disk. | | `file_modified_utc` | `datetime` | File Modified (UTC) | ☑ | When the data file was last written when it was described, in UTC. | | `file_name` | `varchar2(1024)` | File Name | ☑ | Name of the data file within the directory of the table, as the index keys it. | | `file_size_bytes` | `int64` | File Size (bytes) | ☑ | Size of the data file in bytes when it was described. | | `index_file_path` | `varchar2(1024)` | Index File Path | ☑ | Path of the index file the row was read from. | | `indexed_at_utc` | `datetime` | Indexed At (UTC) | ☑ | When the statistics were computed, in UTC. | | `is_current` | `boolean` | Is Current | ☑ | Whether the data file still has the size and moment described, so that the description is used. | | `partition` | `varchar2(255)` | Partition | ☐ | Partition the data file belongs to. | | `row_count` | `int64` | Row Count | ☑ | Number of records the data file held. | | `schema_version` | `number` | Schema Version | ☑ | Version of the shape of the index record. | | `sorted_by` | `varchar2(4000)` | Sorted By | ☐ | Columns the records are sorted by, comma-separated, where they are. | | `table_name` | `varchar2(240)` | Table Name | ☑ | Full name of the table whose index the row comes from. |