# file_metadata: Get the file metadata. - Catalog: `Dropbox` - Schema: `Dropbox` - Primary Keys: `id` - Parameters: path, include_media_info, include_deleted, include_has_explicit_shared_members - Label: Get the file metadata. ## Table Columns The columns of the table `file_metadata` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Nullable | Documentation | |---|:---:|---|:---:|---| | `client_modified` | `datetime` | Client that Modified | ☑ | | | `content_hash` | `string` | Content Hash | ☑ | | | `has_explicit_shared_members` | `boolean` | Has Explicit Shared Members | ☑ | | | `id` | `string` | ID | ☑ | | | `media_info_metadata_photo_dimensions_height` | `int64` | Media Info Metadata Photo Dimensions Height | ☑ | | | `media_info_metadata_photo_dimensions_width` | `int64` | Media Info Metadata Photo Dimensions Width | ☑ | | | `media_info_metadata_photo_location_latitude` | `decimal` | Media Info Metadata Photo Location Latitude | ☑ | | | `media_info_metadata_photo_location_longitude` | `decimal` | Media Info Metadata Photo Location Longitude | ☑ | | | `media_info_metadata_photo_time_taken` | `datetime` | Media Info Metadata Photo Time Taken | ☑ | | | `media_info_metadata_tag` | `string` | Media Info Metadata Tag | ☑ | | | `media_info_metadata_video_duration` | `int64` | Media Info Metadata Video Duration | ☑ | | | `media_info_pending` | `string` | Media Info Pending | ☑ | | | `media_info_tag` | `string` | Media Info Tag | ☑ | | | `name` | `string` | Name | ☑ | | | `parent_shared_folder_id` | `string` | Parent Shared Folder ID | ☑ | | | `path_display` | `string` | Display Path | ☑ | | | `path_lower` | `string` | Path (Lower) | ☑ | | | `property_groups_fields_name` | `string` | Property Groups Fields Name | ☑ | | | `property_groups_fields_value` | `string` | Property Groups Fields Value | ☑ | | | `property_groups_template_id` | `string` | Property Groups Template ID | ☑ | | | `rev` | `string` | Revision | ☑ | | | `server_modified` | `datetime` | Server that Modified | ☑ | | | `shared_folder_id` | `string` | Shared Folder ID | ☑ | | | `sharing_info_modified_by` | `string` | Sharing Information Modified by | ☑ | | | `sharing_info_no_access` | `boolean` | Sharing Info No Access | ☑ | | | `sharing_info_parent_shared_folder_id` | `string` | Sharing Information Parent Shared Folder ID | ☑ | | | `sharing_info_read_only` | `boolean` | Sharing Information (read-only) | ☑ | | | `sharing_info_shared_folder_id` | `string` | Sharing Info Shared Folder ID | ☑ | | | `sharing_info_traverse_only` | `boolean` | Sharing Info Traverse Only | ☑ | | | `size` | `int64` | Size | ☑ | | | `tag` | `string` | Tag | ☑ | |