Question: It is not possible to extract the profile ID (the primary key) field? Is there any other way possible to do this?
The new “ACS ID” feature can be used here. This will generate a new field named “acsId” with the type “UUID”.
We would be able to see it in the SQL preview after the preparation of the publication.
So, its values would be UUID.