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. |