raw_sensor_media_items¶
Info¶
Data contract for copying the Faunabit media items from the landing zone into the blob storage. In this table
we store the items that have been copied to blob and track their original paths.
- name: Sensor Media Items
- version: 0.0.6
- status: active
Terms of Use¶
Purpose¶
Data contract for copying the Faunabit media items from the landing zone into the blob storage. In this table we store the items that have been copied to blob and track their original paths.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: raw_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: faunabit |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: raw_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: faunabit |
Schema¶
sensor_media_items¶
Table storing the sensor media items validated data from Faunabit in the raw layer of the Biocloud.
| Field | Type | Attributes |
|---|---|---|
| blob_path | string | The path on the biocloud blob storage where the media file was copied to. • primaryKey |
| capture_datetime | string | Timestamp when the media was captured, extracted from the file name provided by Faunabit. |
| device_name | string | Name of the device that captured the media, files are written to a folder named after the device. • required |
| mime_type | string | MIME type of the media file. For now this is hardcoded to "image/jpeg". |
| source_path | string | Original source path of the media file before moving it to the blob storage. |
| upload_success | boolean | Indicates whether the media file upload was successful. |
| inserted_ts_utc | timestamp | UTC timestamp when the record was inserted into the system. |
| updated_ts_utc | timestamp | UTC timestamp when the record was last updated in the system. |