Trying to get CDT mapped to a view

Question

Pulling my hair out. I m trying to create a CDT mapped to an existing view in my application's mySQL database. Doing my best to follow these instructions: https://docs.appian.com/suite/help/20.2/Mapping_CDTs_to_Pre-defined_Database_Tables.html . I cannot seem to add it as an Entity to a data store though; it seems the DDL is trying to create a table, but I just want to map to a view ...

Mike Schmitt · Answer

If you're just trying to create a new CDT based on an existing table/view, there shouldn't be a step in the process where any DDL needs to come into it. It's pretty straightforward... 
 
 click "new" -> "data type" 
 select "create from database table or view" radio button 
 select the data source and the view name, click next 
 the "create data type" form pops up with all the pre-populated column names;
 
 the only catch here is that you need to force a primary key column by clicking on the "key" icon and selecting "primary key"; you need to do this even if it's not really a primary key (in a view at least), though for querying reasons i'd strongly suggest you make sure there's at least one column that will basically always have unique values under nominal conditions 
 otherwise, just give the CDT a name (i suggest not using the pre-populated one), and select the Data Store

click "create" 
 
 That's really all it takes. I'm running through it as I type this to make sure. No DDL files involved - where are you seeing that?

Mike Schmitt · Answer

You can open the datastore and verify, but only as a precaution / to double check. When things are working normally AFAIK this is an unnecessary step.