Table Details
| Property | Value |
|---|---|
| Table Name | canton.raw.private_updates |
| Table Status | Production-Ready |
| Unique Key | record_time, update_id |
| Clustering Key(s) | to_date("record_time") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| update_id | VARCHAR(16777216) | Unique identifier of this Canton ledger update. |
| migration_id | NUMBER(38,0) | Identifier of the Canton ledger migration version that produced this event. |
| domain_id | VARCHAR(16777216) | Identifier of the Canton synchronizer domain this verdict belongs to. |
| record_time | TIMESTAMP_NTZ(9) | Time at which this update was recorded by the Canton synchronizer domain. |
| finalization_time | TIMESTAMP_NTZ(9) | Timestamp at which the Canton confirmation protocol finalized this transaction’s verdict. |
| submitting_parties | VARIANT | Array of Canton party IDs that submitted this transaction. |
| submitting_participant_uid | VARCHAR(16777216) | Identifier of the Canton participant node that submitted this transaction. |
| verdict_result | VARCHAR(16777216) | Outcome of the Canton confirmation protocol for this transaction (e.g. accepted or rejected). |
| mediator_group | NUMBER(38,0) | Identifier of the mediator group that coordinated confirmation for this Canton transaction. |
| transaction_views | VARIANT | Nested view tree of a Canton transaction’s verdict: root view indices plus, per view, informees, confirming parties, thresholds, and sub-view indices. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| update_index | NUMBER(38,0) | Sequential index of this update within its containing Canton block. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |