Archive options

By default, archived data is not retrieved for general SELECT statements. You can query for archived data stored in Data Lake with these archive options:

  • Include Archived Records:


    Retrieve a result set exclusive to archive records reflecting the maximum variation of a given identifier.

  • Return All Variations Of Archived Records:


    Retrieve a result set exclusive to archived records that reflects all variations of a given identifier.

  • Include Both Archived & Deleted Records:


    Retrieve a result set where the maximum variation of an identifier may reflect an active, archived, or deleted record.

  • Return All Variations Including Archived Records:


    Retrieve a result set of all variations of an identifier including archived and deleted records.

For more information on querying archived data, see Variation handling.