I am trying to create a Data type using the SQL view, but I am facing the following error:
I am unable to Adding the data type to data store. Any suggestion?
Discussion posts and replies are publicly visible
Can you elaborate on the warning that was presented to you while creating the CDT from the SQL View? Are you following the guidelines for creating a CDT from a view (i.e ensuring the PK exists and is being used in the CDT)
How can I define PK in a view?
Karanc,
Your database view will not have a Primary Key but it should have a unique identifier to each row that it outputs. That unique field will then be used as a PK while configuring the CDT
Please check the below link:
https://docs.appian.com/suite/help/20.3/Mapping_CDTs_to_Pre-defined_Database_Tables.html
Does your CDT have a field with the PK constraint?