Fields included in _acp_system_metadata in Query Service AEP

[Cristhian_AlexisNa]

Hi all,

I would like to know the list of fields that belongs to this metadata path "_acp_system_metadata", I know that one of them is "_acp_system_metadata.ingestTime", but I want the complete list. Please, could anyone provide me this?

Thank you!

Cristhian N

[supratim320 · Accepted solution]

You can run an quick query to get the columns:

set drop_system_columns=false;

SELECT to_json(_acp_system_metadata) FROM {your_table}
LIMIT 1

Below are the columns I can spot (I ran it for 1st time, so not sure which is what and not much help in offer from document😞

1. acp_sourceBatchId
2. commitBatchId
3. trackingId
4. rowId
5. rowVersion
6. primaryIdentity
7. namespace
8. ingestTime (you already know this one)
9. isDeleted