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:
Envelope fields generation counter
The expected non-zero value if the entity type doesn’t use soft deletes.
SQL name | envelope_fields_generation_counter |
|---|---|
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 | envelope_fields_is_tombstone |
|---|---|
Data type | Boolean |
Envelope fields resource ARI value
The unique identifier of the entity.
SQL name | envelope_fields_resource_ari_value |
|---|---|
Data type | String |
Envelope fields version
The sequence number to determine the order of events received.
SQL name | envelope_fields_version |
|---|---|
Data type | BigInt |
Envelope fields workspace ID value
The replication workspace that this entity is part of.
SQL name | envelope_fields_workspace_id_value |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Timestamp |
Row refreshed at day
The date of the last refresh time for this record.
SQL name | row_refreshed_at_day |
|---|---|
Data type | Date |
Shard ID
An Atlassian identifier to help partition the underlying data.
SQL name | shard_id |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site.
SQL name | workspace_id |
|---|---|
Data type | String |
Was this helpful?