stg_gcs__rfx_permissions

staging view

The procurement RBAC matrix, typed.

Definition

Cleaned mirror of `raw_gcs.rfx_permissions`. Coerces the CSV's `Nullable(String)` columns into typed equivalents. Reference data describing the intended access policy for procurement personas — no personal data.

9 of 9

Column

Description

Tests · PII

permission_id

UUID5 from the source CSV. Primary key.

2 tests

role

RFX role the rule applies to.

2 tests

resource_type

Resource the rule governs.

2 tests

action

Action the rule governs.

2 tests

effect

Whether the rule grants or denies access.

2 tests

scope_filter

Scope expression bounding the rule (e.g. `region='NA'`, or `*` for all). Free-text.

source_file_url

Airbyte-supplied `_ab_source_file_url` — the gs:// URI the row came from.

source_file_modified_at

Airbyte-supplied `_ab_source_file_last_modified` — object mtime of the source file.

airbyte_extracted_at

When Airbyte extracted this row from GCS.