raw_locations¶

Info¶

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

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

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

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

Field	Type	Attributes
address	string	Street address of the location.
city	string	City where the location is situated.
country	string	Country where the location is located.
country_code	string	2-letter ISO country code of the location.
created_at	string	Timestamp when the record was originally created.
deleted_at	string	Timestamp when the record was marked as deleted (if applicable).
emails	array	List of associated email addresses.
↳ items	string	No description.
id	bigint	Primary unique identifier of the record. • `primaryKey` • `required`
lat	double	Latitude of the location. • `required`
location_type_id	bigint	Unique identifier of the location type.
lon	double	Longitude of the location. • `required`
name	string	Name of the location.
organization_id	bigint	Unique identifier of the associated organization.
owner	boolean	Indicates whether the user is the owner (true/false).
postal_code	string	Postal or ZIP code of the location.
timezone	string	Time zone of the location.
type	string	Type or category of the location.
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.