enriched_media_item¶
Info¶
Data contract for the Media Item table of the media domain of the Biocloud. Contains metadata about images and videos captured by sensors, with references to blob storage locations. - name: Media Item - version: 0.0.1 - status: active
Terms of Use¶
Purpose¶
Data contract for the Media Item table of the media domain of the Biocloud. Contains metadata about images and videos captured by sensors, with references to blob storage locations.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: media_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: enriched |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: media_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: enriched |
Schema¶
media_item¶
The media item table contains metadata about images and videos captured by sensors. Each record represents a single media file stored in blob storage with associated metadata. This table must be processed after sensor and deployment tables.
| Field | Type | Attributes |
|---|---|---|
| media_item_id | bigint | Biocloud generated identifier for the media item. • primaryKey• primaryKeyPosition: 1 • required |
| sensor_golden_id | bigint | Foreign key to the sensor table, linking to the sensor that captured this media. |
| sensor_name | string | Name of the sensor that captured this media. • examples: ['DIOPSIS-212', 'CAM-001'] |
| deployment_id | bigint | Foreign key to the deployment table, linking to the active deployment when this media was captured. |
| deployment_name | string | Name of the deployment associated with this media capture. |
| uri | string | Full S3 URI to the media file in blob storage. • required• examples: ['s3://biocloud-media-bucket/path/to/image.jpg'] |
| capture_ts_utc | timestamp | UTC timestamp when the media file was recorded/captured by the sensor. • required |
| kind | string | Type of media content. • examples: ['image', 'video', 'audio'] |
| mime_type | string | MIME type of the media file. • examples: ['image/jpeg', 'image/png', 'video/mp4'] |
| upload_success | boolean | Boolean indicating if the upload to blob storage completed successfully. |
| source | string | The name of the source system used to create this record in the table. • required• examples: ['diopsis', 'faunabit'] |
| last_updated_source | string | The source system that last updated this record. |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |