Metadata columns in data shares
Analytics is now Insights
All of the Analytics capabilities of the app remain unchanged. You can continue using your existing dashboards, charts, and smart links alongside the new Rovo-powered features. These features combine work and data context to provide reliable answers, create a shared understanding of data, and build dashboards that your team can depend on.
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. Use this as the physical primary key for all tables.
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 |
Row refreshed at hour
Hour when the particular row was inserted/updated.
SQL name |
|
|---|---|
Data type | String |
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?