Manual Queries (Transformation)
SQL statements that run during source processing, in the order listed on this page.
Open Transformation › Setup › Manual Queries in the app.
Matching-package queries live under Reconciliation › Setup › Manual Queries (linked from this page).
What you can do
- Add, edit, enable/disable, reorder, and delete transformation manual queries
- Attach queries to specific sources (or leave them broader, depending on object selection)
- Search by statement, type, or description
Columns typically include Sequence number, ID, Statement, Status, Type, and Objects.
Sequence numbers can skip values because they are shared across source and matching-package query lists.
If none exist yet, the page shows No manual queries yet.
Add a query
- Choose Add query.
- Enter the statement (plain SQL, run as written — it is not validated in the UI).
- Set type, status (Enabled / Disabled), description, and which objects (sources) it applies to.
- Save. Drag to reorder, then Save sorting so the run order sticks.
When they run
Queries run in sequence as part of source processing (the same pipeline driven by the 
Transformation Schedule or a manual reprocess).
Transformation Schedule or a manual reprocess).Permissions
Adding, editing, reordering, or deleting queries requires the appropriate permissions.