Fields included in _acp_system_metadata in Query Service AEP | Community
Skip to main content
C
Cristhian_AlexisNa
Level 2
March 13, 2025
Solved

Fields included in _acp_system_metadata in Query Service AEP

  • March 13, 2025
  • 1 reply
  • 939 views

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

Best answer by supratim320

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

1 reply

S
supratim320Accepted solution
Level 5
March 13, 2025

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
    Terms & ConditionsAccessibility statement

    Loading footer...