Metadata columns in data shares
Data shares aren’t available in the Atlassian Government environment.
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?