Monitoring & Diagnostic Views

Views for integration process tracking and access control.

VW_INTEGRATION_PROCESS

Integration process tracking and status.

Contents: Integration process date, feature type, integration type, user name, attribute count, file path

Use cases: Integration monitoring, process tracking

VW_ACCESS_CONTROL_USER_PRIVILEGES

User access control and privilege information.

Contents: User privilege information, access control settings, entity names, privilege names, grant status, timestamps

Note: Available to app_admin role only.

Use cases: Access control management, security auditing

---

Common Query Patterns

Monitoring active scans:

SELECT datasource_name, configuration_name, scan_status, percentage_complete,
       estimated_records_remaining, process_time_remaining_in_minutes
FROM core.vw_datasource_scans_in_process
ORDER BY scan_datetime_begin DESC;

Reviewing scan history:

SELECT datasource_name, configuration_name, scan_datetime_begin, scan_duration_minutes,
       records_processed, records_processed_per_minute, scan_status
FROM core.vw_datasource_scans
WHERE datasource_id = 'your-datasource-id'
ORDER BY scan_datetime_begin DESC LIMIT 10;

Monitoring schema drift:

SELECT version_number, attribute_path, polymorphic_attribute_name, version_status, version_status_date
FROM core.vw_datasource_version_all_attributes
WHERE datasource_id = 'your-datasource-id' AND version_status_date >= CURRENT_DATE - 7
ORDER BY version_number DESC, version_status_date DESC;

Reviewing security configuration:

SELECT attribute_path, polymorphic_attribute_name, include_column_in_row_access_policy,
       column_masking_policy_name, view_name
FROM core.vw_datasource_attribute_security
WHERE datasource_id = 'your-datasource-id'
  AND (include_column_in_row_access_policy = TRUE OR column_masking_policy_name IS NOT NULL);