Reference for Data Safe

This section provides information about views within OCI Resource Analytics Data Safe and their columns, data types, keys, and the referred view and column names. The following views are available:

The suffixes in the view names designate the view type:

• FACT_V: Fact
• DIM_V: Dimension

The contents of each view and their relationships are listed in the following file: Data Safe views.

Each tab in the Excel spreadsheet contains the details of a view.

This section provides diagrams that define the logical relationship of a fact table with different dimension tables.

These diagrams show the relationship of the Data Safe fact view with different dimension views.

DATA_SAFE_AUDIT_PROFILE_FACT_V

DATA_SAFE_AUDIT_TRAIL_FACT_V

DATA_SAFE_DISCOVERY_JOB_FACT_V

DATA_SAFE_MASKING_POLICY_HEALTH_REPORT_FACT_V

DATA_SAFE_SECURITY_ASSESSMENT_FACT_V

DATA_SAFE_TARGET_DATABASE_FACT_V

DATA_SAFE_USER_ASSESSMENT_FACT_V

Relationships exist among dimensions. Dimensions can be joined directly to each other. This diagram shows the relationship between dimension views.

DATA_SAFE_ALERT_POLICY_DIM_V

DATA_SAFE_ATTRIBUTE_SET_DIM_V

DATA_SAFE_AUDIT_ARCHIVE_RETRIEVAL_DIM_V

DATA_SAFE_AUDIT_POLICY_DIM_V

DATA_SAFE_DATABASE_SECURITY_CONFIG_DIM_V

DATA_SAFE_LIBRARY_MASKING_FORMAT_DIM_V

DATA_SAFE_MASKING_REPORT_DIM_V

DATA_SAFE_ON_PREM_CONNECTOR_DIM_V

DATA_SAFE_PRIVATE_ENDPOINT_DIM_V

DATA_SAFE_REPORT_DEFINITION_DIM_V

DATA_SAFE_REPORT_DIM_V

DATA_SAFE_SDM_MASKING_POLICY_DIFFERENCE_DIM_V

DATA_SAFE_SECURITY_POLICY_CONFIG_DIM_V

DATA_SAFE_SECURITY_POLICY_DEPLOYMENT_DIM_V

DATA_SAFE_SECURITY_POLICY_DIM_V

DATA_SAFE_SECURITY_POLICY_REPORT_DIM_V

DATA_SAFE_SENSITIVE_TYPES_EXPORT_DIM_V

DATA_SAFE_SENSITIVE_TYPE_DIM_V

DATA_SAFE_SENSITIVE_TYPE_GROUP_DIM_V

DATA_SAFE_SQL_FIREWALL_POLICY_DIM_V

DATA_SAFE_TARGET_ALERT_POLICY_ASSOCIATION_DIM_V

DATA_SAFE_UNIFIED_AUDIT_POLICY_DEFINITION_DIM_V

DATA_SAFE_UNIFIED_AUDIT_POLICY_DIM_V

Sample queries for Data Safe.

List the number of audit profiles associated with each target ID.

SELECT
    TARGET_ID,
    COUNT(AUDIT_PROFILE_ID) AS AUDIT_PROFILE_COUNT
FROM OCIRA.DATA_SAFE_AUDIT_PROFILE_FACT_V F
GROUP BY TARGET_ID;

List the number of audit trails associated with each audit profile ID.

SELECT
    AUDIT_PROFILE_ID,
    COUNT(AUDIT_TRAIL_ID) AS AUDIT_TRAIL_COUNT
FROM OCIRA.DATA_SAFE_AUDIT_TRAIL_FACT_V F
GROUP BY AUDIT_PROFILE_ID;

List the number of discovery jobs associated with each target ID.

SELECT
    TARGET_ID,
    COUNT(DISCOVERY_JOB_ID) AS DISCOVERY_JOB_COUNT
FROM OCIRA.DATA_SAFE_DISCOVERY_JOB_FACT_V F
GROUP BY TARGET_ID;

List the number of masking policy health reports associated with each masking policy ID.

SELECT
    MASKING_POLICY_ID,
    COUNT(MASKING_POLICY_HEALTH_REPORT_ID) AS MASKING_POLICY_HEALTH_REPORT_COUNT
FROM OCIRA.DATA_SAFE_MASKING_POLICY_HEALTH_REPORT_FACT_V F
GROUP BY MASKING_POLICY_ID;

List the number of security assessments associated with each target database group ID.

SELECT
    TARGET_DATABASE_GROUP_ID,
    COUNT(SECURITY_ASSESSMENT_ID) AS SECURITY_ASSESSMENT_COUNT
FROM OCIRA.DATA_SAFE_SECURITY_ASSESSMENT_FACT_V F
GROUP BY TARGET_DATABASE_GROUP_ID;

List active target databases.

SELECT
    TARGET_DATABASE_ID,
    DISPLAY_NAME,
    LIFECYCLE_STATE
FROM OCIRA.DATA_SAFE_TARGET_DATABASE_FACT_V F
WHERE LIFECYCLE_STATE = 'ACTIVE';

List the number of user assessments associated with each target database group ID.

SELECT
    TARGET_DATABASE_GROUP_ID,
    COUNT(USER_ASSESSMENT_ID) AS USER_ASSESSMENT_COUNT
FROM OCIRA.DATA_SAFE_USER_ASSESSMENT_FACT_V F
GROUP BY TARGET_DATABASE_GROUP_ID;

The Customer Experience Semantic Model Lineage spreadsheet and Metric Calculation Logic spreadsheet for Data Safe provide an end-to-end data lineage summary report for physical and logical relationships in your data.

For more information, see Data Lineage.

This section provides information on the subject areas with data you maintain in Data Safe. These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:

• Description of the subject area.

• Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.

• Job-specific groups and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.

• Primary navigation to the work area that's represented by the subject area.

• Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.

• The lowest grain of transactional data in a subject area. The lowest transactional data grain decides how data are joined in a report.

• Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.

Oracle Cloud Infrastructure Documentation / API Reference

• Oracle Cloud Infrastructure Data Safe Documentation
• AlertPolicy Reference
• AlertPolicy Reference
• AttributeSet Reference
• AuditArchiveRetrieval Reference
• AuditPolicy Reference
• AuditProfile Reference
• AuditTrail Reference
• DatabaseSecurityConfig Reference
• DataSafePrivateEndpoint Reference
• DiscoveryJob Reference
• LibraryMaskingFormat Reference
• MaskingPolicy Reference
• MaskingPolicyHealthReport Reference
• MaskingReport Reference
• OnPremConnector Reference
• Report Reference
• ReportDefinition Reference
• SdmMaskingPolicyDifference Reference
• SecurityAssessment Reference
• SecurityPolicy Reference
• SecurityPolicyConfig Reference
• SecurityPolicyDeployment Reference
• SecurityPolicyReport Reference
• SensitiveDataModel Reference
• SensitiveType Reference
• SensitiveTypeGroup Reference
• SensitiveTypesExport Reference
• SqlFirewallPolicy Reference
• TargetAlertPolicyAssociation Reference
• TargetDatabase Reference
• TargetDatabaseGroup Reference
• UnifiedAuditPolicy Reference
• UnifiedAuditPolicyDefinition Reference
• UserAssessment Reference