Skip to content

raw_devices

Info

Data contract for ingesting Media Devices data from the landing zone into raw. - name: Devices - version: 0.0.6 - status: active

Terms of Use

Purpose

Data contract for ingesting Media Devices data from the landing zone into raw.

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

devices

Table storing the deployments validated data from Faunabit in the raw layer of the Biocloud.

Field Type Attributes
alerts string Alert messages or flags associated with the device or record.
boot_count bigint Number of times the device has been booted.
color string Color of the device.
cpu_disk_free bigint Amount of free disk space available on the device.
cpu_load double Current CPU load or utilization.
cpu_memory_free bigint Amount of free memory available on the device.
cpu_swap_free bigint Amount of free swap space available on the device.
cpu_temperature double Current CPU temperature.
created_at string Timestamp when the record was originally created.
deleted_at string Timestamp when the record was marked as deleted (if applicable).
enable_weather boolean Indicates whether weather-related features are enabled.
firmware_version string Version of the device firmware.
id bigint Primary unique identifier of the record.
• primaryKey
• required
last_image string URL or identifier of the last image captured.
last_message_received string Timestamp of the last message received from the device.
last_photo_date string Timestamp of the last photo captured.
last_seen_date string Timestamp when the device was last seen online.
last_thumb string URL or identifier of the last thumbnail image.
location_research_end string End date of the associated research at the location.
location_research_id bigint Unique identifier of the associated location research.
location_research_name string Name of the associated location research.
location_research_start string Start date of the associated research at the location.
mode string Current operating mode of the device.
name string Name or label of the device.
• required
online boolean Indicates whether the device is currently online.
organization_id bigint Unique identifier of the associated organization.
owner boolean Indicates whether the user is the owner (true/false).
phone_number string Phone number associated with the device SIM.
photos_last_24h bigint Number of photos captured in the last 24 hours.
research_name string Name of the associated research project.
settings_updated_at string Timestamp when the device settings were last updated.
sim_number string SIM card number associated with the device.
fw_version string New column added by Faunabit to store the firmware version.
photos_uploaded_until string New column added by Faunabit to store the firmware version.
status struct Nested status metrics and last activity indicators.
 ↳ last_msg_min number Minutes since the last message was received.
 ↳ last_photo_min number Minutes since the last photo was captured.
 ↳ last_seen_min number Minutes since the device was last seen online.
 ↳ lat number Latitude of the device location.
 ↳ lon number Longitude of the device location.
style string Model, style, or form factor of the device.
voltage double Current voltage level of the device.
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.
source_data_version string Version of the source data used to generate this record.

SLA Properties