# file_info: Windows File Metadata Properties - Catalog: `FileSystem` - Label: File Metadata Properties - Retrieve: true ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `ignore_errors` | `boolean` | ☐ | | Whether to ignore errors when accessing the file. Defaults to false. | | `path` | `string` | ☑ | | Relative or absolute path to the file. | ## Columns of Table Function The columns of the table function `file_info` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_utc` | `datetime` | | ☐ | | | `created` | `datetime` | | ☐ | | | `directory_name` | `string` | Directory Name | ☐ | | | `exception_code` | `string` | | ☐ | The message code of the error. | | `exception_message` | `string` | | ☐ | The text of the error. | | `extension` | `string` | | ☐ | | | `is_archive` | `boolean` | Is Archive File | ☐ | | | `is_compressed` | `boolean` | Is Compressed File | ☐ | | | `is_content_indexed` | `boolean` | Is Content Indexed File | ☐ | | | `is_device` | `boolean` | Is Device File | ☐ | | | `is_directory` | `boolean` | Is Directory | ☐ | | | `is_encrypted` | `boolean` | Is Encrypted File | ☐ | | | `is_existing` | `boolean` | | ☐ | | | `is_hidden` | `boolean` | Is Hidden File | ☐ | | | `is_integrity_stream` | `boolean` | Is Integrity Stream File | ☐ | | | `is_normal` | `boolean` | Is Normal File | ☐ | | | `is_offline` | `boolean` | Is Offline File | ☐ | | | `is_reparse_point` | `boolean` | Is Reparse Point File | ☐ | | | `is_scrub_data` | `boolean` | Is Scrub Data File | ☐ | | | `is_sparse` | `boolean` | Is Sparse File | ☐ | | | `is_system` | `boolean` | Is System File | ☐ | | | `is_temporary` | `boolean` | Is Temporary File | ☐ | | | `is_writable` | `boolean` | Is Writable File | ☐ | | | `last_access_utc` | `datetime` | | ☐ | | | `last_access` | `datetime` | | ☐ | | | `last_write_utc` | `datetime` | | ☐ | | | `last_write` | `datetime` | | ☐ | | | `length` | `int64` | File Size (bytes) | ☐ | | | `name` | `string` | Name | ☐ | |