# FILES_PER_FOLDER: Files per Folder ## Documentation Scan directory for file and directory names. - Name: `FILES_PER_FOLDER` - Catalog: `FTP` - Label: Files per Folder - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `remote_directory_path` | `string` | ☑ | | | ## Table Columns The columns of the table `FILES_PER_FOLDER` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `chmod` | `int32` | | | File permissions. | | `date_created` | `datetime` | | ☐ | | | `date_last_modified` | `datetime` | | ☐ | | | `directory_name` | `string` | | ☐ | | | `file_name` | `string` | | ☐ | | | `group_permissions` | `string` | | | Group permissions, combination of None, Execute, Read and Write. | | `link_count` | `int32` | | | Number of files pointing to this file. | | `link_object_name` | `string` | | | Full name of the link target. | | `link_target` | `string` | | | Link target. | | `other_permissions` | `string` | | | Other user permissions, combination of None, Execute, Read and Write. | | `owner_permissions` | `string` | | | Owner permissions, combination of None, Execute, Read and Write. | | `raw_input` | `string` | | | Input string parsed to generate this row. | | `raw_permissions` | `string` | | | Input string parsed to generate the permissions. | | `size_bytes` | `int64` | | ☐ | | | `special_permissions` | `string` | | | Special permissions, such as sticky, SUID and SGID. | | `type` | `string` | | | Type of file system object (file, directory or link). |