enriched_user_permission¶
Info¶
Data contract for the User Permission table of the keycloak domain of the Biocloud. Contains information about user permissions on deployments that will be synced to Keycloak for access control. - name: User Permission - version: 0.0.1 - status: active
Terms of Use¶
Purpose¶
Data contract for the User Permission table of the keycloak domain of the Biocloud. Contains information about user permissions on deployments that will be synced to Keycloak for access control.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: media_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: enriched |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: media_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: enriched |
Schema¶
user_permission¶
The User Permission table contains information about user access permissions for deployments. This data is used to synchronize permissions to Keycloak for access control in the curated layer. This table must be processed after the deployment table.
| Field | Type | Attributes |
|---|---|---|
| user_permission_id | bigint | Biocloud generated identifier for the user permission record. • primaryKey• primaryKeyPosition: 1 • required |
| resource_name | string | Name of the resource in Keycloak (formatted as deployment:source:id). • required• examples: ['deployment:diopsis:123', 'deployment:faunabit:456'] |
| email_hashed | string | Hashed email address of the user with permission. • required |
| deployment_name | string | Name of the deployment for which permission is granted. |
| deployment_id | bigint | Foreign key to the deployment table. • required |
| deployment_source_id | string | Source system ID of the deployment. • required |
| deployment_all_emails_hashed | array | Array of all hashed email addresses with access to this deployment. |
| ↳ items | string | No description. |
| user_id | string | Keycloak user ID for the user with permission. |
| username_hashed | string | Hashed username of the user in Keycloak. |
| resource_id | string | Keycloak resource ID if the resource has already been created. |
| deployment_source | string | Source system of the deployment. • required• examples: ['diopsis', 'faunabit', 'diopsis_v1'] |
| last_updated_source | string | The source system that last updated this record. |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |