Skip to content

raw_projects

Info

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

Terms of Use

Purpose

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

projects

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

Field Type Attributes
created_at string Timestamp when the record was originally created.
deleted_at string Timestamp when the record was marked as deleted (if applicable).
deployments array List of associated deployment identifiers.
 ↳ items bigint No description.
description string Detailed description of the record or project.
end_date string End date of the deployment, project, or record.
id bigint Primary unique identifier of the record.
primaryKey
required
name string Name or title of the record.
required
organization_id bigint Unique identifier of the associated organization.
start_date string Start date of the deployment, project, or record.
required
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