I am Facing Some Issues While Mapping Data store entity.
I have created a view by joining three tables, and I obtained the exact data. Then, I created a CDT (Custom Data Type). However, when I attempted to map it into a data store, it failed and displayed an error.
Discussion posts and replies are publicly visible
I suggest to check the DDL Appian created and adapt the CDT and/or the view to match each other.
Did you try creating the CDT by using the "Create from database table or view" option?