AO Table Export Specification

Overview

The AO Table files contain the Vendor AO table data from DC. The file follows the format in Export File Specification.

A file is generated for each AO Table owned by the Vendor. There may be more than one file per table, as files may be provided incrementally or split across multiple files when they exceed the chunking limit.

AO table exports are notified through the event-file-list-uploaded event with a label of DATABASE (see the Event Specification).

Onboarding

Please reach out to Atlassian to test the early access feature.

Metadata Header (First Row)

The first line of every export file contains metadata about the export. The meta contains the table name, and column definitions from the DC table. All columns from the DC AO tables will be included.

Example metadata line (formatted for readability)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
{
  "table":"AO_6FF49D_DOMAIN_SCAN",
  "columns":[
    {"name":"BLOCKED_DOMAINS_COUNT","type":"number","size":64,"nullable":true},
    {"name":"DISTINCT_DOMAINS_COUNT","type":"number","size":64,"nullable":true},
    {"name":"EXECUTION_TIME","type":"number","size":64,"nullable":true},
    {"name":"FINISHED_AT","type":"number","size":64,"nullable":true},
    {"name":"ID","type":"varchar","size":-1,"nullable":false},
    {"name":"LOOKUP_METHOD","type":"varchar","size":-1,"nullable":true},
    {"name":"STARTED_AT","type":"number","size":64,"nullable":true},
    {"name":"STATUS","type":"varchar","size":-1,"nullable":true},
    {"name":"DELETED","type":"boolean","size":1,"nullable":false}, // Added by migration platform
    {"name":"TXN_SEQUENCE","type":"integer","size":19,"nullable":false} // Added by migration platform
  ],
  "primaryKeys":["ID"],
  "rowCount":0,
  "TYPE":"METADATA"}

Data Record Lines

The data records lines contain the data from the DC tables.

Example data record line (formatted for readability)

1
2
3
4
5
6
7
8
9
10
11
12
13
{
  "BLOCKED_DOMAINS_COUNT":0,
  "DISTINCT_DOMAINS_COUNT":1,
  "EXECUTION_TIME":3923,
  "FINISHED_AT":1773982903301,
  "ID":"821a09b3-8593-4c4b-a636-e483564f4d01",
  "LOOKUP_METHOD":"UMS",
  "STARTED_AT":1773982899378,
  "STATUS":"FINISHED",
  "DELETED":false, // Added by migration platform
  "TXN_SEQUENCE":0 // Added by migration platform
}