Hello,
I have recently installed VSCode and the Oracle SQL Developer extension. I am extremely impressed with it so far and have started experimenting with the AI features.
One area I seem to be struggling with is the AI Enrichment feature.
The tables in my schema did not have any annotations, so I was able to create them by writing a script to basically copy the table and column comments to annotations. After activating the AI Enrichment and creating the necessary database objects, the AI "Database Enrichment Percentage" remains at 0%.
Do I understand this correctly that the AI Enrichment data can be seeded from the annotations?
I have even tried narrowing this down to one particular database table and checked that all the necessary annotations are there to regard the table as "Enriched". So for this particular table, there's a table-level annotation, column-level annotations and also a primary key:
SELECT annotation_name, annotation_value
FROM user_annotations_usage
WHERE object_name = 'STVDEPT'
AND column_name IS NULL
ANNOTATION_NAME, ANNOTATION_VALUE
ANNOTATION_DATE 2025-12-02
BANNER_MODULE Banner Validation Table
CONTAINS_PII No
DESCRIPTION Department Validation Table
FERPA_PROTECTED No
SCHEMA SATURN
TABLE_TYPE Validation/Reference Table
USAGE Validation/lookup table - join for descriptions
SELECT column_name, annotation_name, annotation_value
FROM user_annotations_usage
WHERE object_name = 'STVDEPT'
AND column_name IS NOT NULL
ORDER BY column_name, annotation_name
COLUMN_NAME, ANNOTATION_NAME, ANNOTATION_VALUE
STVDEPT_ACTIVITY_DATE DESCRIPTION This field identifies the most recent date a record was created or updated.
STVDEPT_ACTIVITY_DATE PII No
STVDEPT_CODE DESCRIPTION This field identifies the department code referenced in the Catalog, Recruiting, Admissions, and Acad. Hist. Modules. Required value: 0000 - Dept. Not Declared.
STVDEPT_CODE PII No
STVDEPT_DATA_ORIGIN DESCRIPTION DATA ORIGIN: Source system that created or updated the data.
STVDEPT_DESC DESCRIPTION This field specifies the department associated with the department code.
STVDEPT_SURROGATE_ID DESCRIPTION SURROGATE ID: Immutable unique key
STVDEPT_SYSTEM_REQ_IND DESCRIPTION System Required Indicator
STVDEPT_SYSTEM_REQ_IND PII No
STVDEPT_USER_ID DESCRIPTION USER ID: The user ID of the person who inserted or last updated this record.
STVDEPT_VERSION DESCRIPTION VERSION: Optimistic lock token.
STVDEPT_VPDI_CODE DESCRIPTION VPDI CODE: Multi-entity processing code.
STVDEPT_VPDI_CODE PII No
STVDEPT_VR_MSG_NO DESCRIPTION The Voice Response message number assigned to the recorded message that describes the department code.
SELECT constraint_name, constraint_type, status
FROM user_constraints
WHERE table_name = 'STVDEPT'
AND constraint_type = 'P'
CONSTRAINT_NAME, CONSTRAINT_TYPE, STATUS
PK_STVDEPT P ENABLED
However, when I look at the table "STVDEPT" in the AI Enrichment dashboard, the table description and column descriptions are still blank.
I'm assuming that these would be populated automatically from the annotation data.
Is this the case? I have tried refreshing various connections and windows, but to no avail. Any advice much appreciated!
Reagrds,
Paul