Identifying primary keys from tables already in Qlik Replicate
I understand Qlik requires tables to have a primary key in order to perform replication. Is there a way to see a list of those fields that Qlik is using for primary keys for a given replication function? I tried exporting the task (from the web UI) which connects to the database source but that doesn't seem to have any details about the tables' primary keys.
Does anyone know how I can pull this information out of Qlik Replicate somehow?
Wow, thank you for the lightning fast reply!! For your first suggestion (Designer Mode/Table Settings), that would be limited to a single table at a time correct?
For the second suggestion, could you let me know where that metastore.sqllite file resides? Would I need console access to the server in order to retrieve it? Also is there anything available from the API that might help here?
Thank you! So when I run that command (repctl dumpmetadata) it will generate that "table_defs" folder which has the files I need within? Sorry but I've never worked with sqlite data before so this is all rather new to me.