Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
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?