Add a schema viewer and schema-path autocomplete to AEP Query Service

When writing queries in Adobe Experience Platform Query Service, the editor provides assistance for selecting available tables. However, after selecting a table, users still need to leave Query Service and inspect the corresponding schema to identify the available schema paths and fields.

It would be highly beneficial to provide an integrated schema viewer within Query Service. Once a table is selected, users should be able to browse the related schema and select from the available schema paths directly in the query editor.

Suggested functionality

• Display the schema associated with the selected table or dataset.
• Provide a searchable, expandable list of available schema paths and fields.
• Support autocomplete for schema paths while writing a query.
• Allow users to click a schema path to insert it into the query.
• Display useful metadata, such as field data type and whether a field is nested.
• Keep the schema information synchronised with the selected table or dataset.

Benefits

This enhancement would:

• Reduce the need to switch between Query Service and the Schema or Dataset UI.
• Make query development faster and more efficient.
• Reduce errors caused by incorrect or outdated schema paths.
• Improve discoverability of nested fields and complex data structures.
• Make Query Service more accessible to users who are less familiar with the underlying schemas.

Example use case

A user selects a dataset in Query Service and wants to filter on a nested customer attribute. Instead of opening the schema separately and manually copying the path, the user can expand the schema viewer, locate the required field, and insert the correct schema path directly into the query.

Expected outcome

Query Service should provide contextual schema guidance in the query editor, similar to the existing table assistance, allowing users to discover and insert valid schema paths without leaving the query-writing experience.