Skip to content

raw_deployments

Info

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

Terms of Use

Purpose

Data contract for ingesting Media Deployments 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

deployments

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

Field Type Attributes
aim string Purpose or objective of the session or record.
conclusion string Final outcome, summary, or result of the session or record.
created_at string Timestamp when the record was originally created.
deleted_at string Timestamp when the record was marked as deleted (if applicable).
device_color string Color of the device used.
device_id bigint Unique identifier of the device.
device_name string Human-readable name of the device.
device_style string Model, style, or form factor of the device.
emails array List of extra emails who have access on this deployment in Faunabit.
 ↳ items string No description.
end string End time of the deployment.
id bigint Primary unique identifier of the deployment set by Faunabit.
• primaryKey
• required
last_inspection_date string Date when the device or subject was last inspected.
legs_unfolded bigint This is an Enum, 1 if the legs are unfolded, 0 if the legs are folded and null if not determined.
location_id bigint Faunabit identifier of the location (can be linked to the locations dataset).
location_name string Human-readable name of the location.
name string Name or title of the record or entity.
• required
• examples: ['Ooijpolder - Groesbeek', 'Wadi Yuvertapark']
organization_id bigint Unique identifier of the associated organization.
owner boolean Indicates whether the user is the owner (true/false).Currently it's always false.
position_source_gps bigint Flag or code indicating if position was sourced from GPS.
research_id bigint Unique identifier of the related research project.
research_subject_id bigint Unique identifier of the related research subject.
screen_bottom_height_cm bigint Height of the bottom of the screen in centimeters.
screen_vertical bigint Indicator or value describing vertical screen position.
start string Start time of the session or event.
• required
subject string Subject or topic associated with the record.
updated_at string Timestamp when the record was last updated.
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.
emails_hashed array List of hashed email addresses for privacy, list built from the emails field.
 ↳ items string No description.
screen_orientation string Orientation of the screen (e.g., portrait or landscape).
source_data_version string Version of the source data used to generate this record.

SLA Properties