Metadata columns in data shares
Metadata columns are used for record management within the Atlassian Data Lake.
The following metadata columns are present in all tables available in a data share:
DB SQL merge at
An internal monitoring timestamp of the last refresh time.
SQL name |
|
|---|---|
Data type | Timestamp |
Envelope fields generation counter
The expected non-zero value if the entity type doesn’t use soft deletes.
SQL name |
|
|---|---|
Data type | BigInt |
Envelope fields is tombstone
A deletion marker for the entity, used to signal to the replica service that the source service soft-deleted this entity. Read more about tombstone records.
SQL name |
|
|---|---|
Data type | Boolean |
Envelope fields resource ARI value
The unique identifier of the entity.
SQL name |
|
|---|---|
Data type | String |
Envelope fields tracing source
Records and tracks the source of a data record’s ingestion or update.
SQL name |
|
|---|---|
Data type | String |
Envelope fields version
The sequence number to determine the order of events received.
SQL name |
|
|---|---|
Data type | BigInt |
Envelope fields workspace ID value
The replication workspace that this entity is part of.
SQL name |
|
|---|---|
Data type | String |
Intermediate-refined (IR) refreshed at
An internal monitoring timestamp of the last refresh time.
SQL name |
|
|---|---|
Data type | Timestamp |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
|---|---|
Data type | Timestamp |
Row refreshed at day
The date of the last refresh time for this record.
SQL name |
|
|---|---|
Data type | Date |
Shard ID
An Atlassian identifier to help partition the underlying data.
SQL name |
|
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site.
SQL name |
|
|---|---|
Data type | String |
Was this helpful?