> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Transforms

### Table Details

| Property            | Value                                                                    |
| ------------------- | ------------------------------------------------------------------------ |
| Table Name          | `casper.raw.transforms`                                                  |
| Table Status        | Production-Ready                                                         |
| Unique Key          | `block_timestamp`, `block_height`, `transaction_hash`, `transform_index` |
| Clustering Key(s)   | `to_date("block_timestamp")`                                             |
| Search Optimization | `transaction_hash`, `block_height`                                       |

### Table Columns

| Column Name         | Data Type         | Description                                                           |
| ------------------- | ----------------- | --------------------------------------------------------------------- |
| key                 | VARCHAR(16777216) | Global state key being transformed (e.g., account, URef, dictionary). |
| transform\_type     | VARCHAR(16777216) | High-level type of the transform (e.g., Write, Add, Prune).           |
| write\_type         | VARCHAR(16777216) | Specific written value type (e.g., CLValue, Account, Contract).       |
| transform\_value    | VARCHAR(16777216) | Serialized value applied by the transform.                            |
| kind                | VARCHAR(16777216) | Kind of state change (Write, Add, Identity, Prune, etc.).             |
| era\_id             | NUMBER(38,0)      | Era (epoch) the block belongs to.                                     |
| transform\_index    | NUMBER(38,0)      | Index of the transform within the transaction's execution result.     |
| block\_timestamp    | TIMESTAMP\_NTZ(9) | Timestamp of the block this event was included in.                    |
| block\_height       | NUMBER(38,0)      | Height of the block this event was included in.                       |
| block\_hash         | VARCHAR(16777216) | Hash of the block this event was included in.                         |
| transaction\_hash   | VARCHAR(16777216) | Hash of the transaction this event belongs to.                        |
| transaction\_index  | NUMBER(38,0)      | Index of the transaction within the block.                            |
| transform\_version  | VARCHAR(16777216) | Version of the transform format.                                      |
| transaction\_result | VARCHAR(16777216) | Execution result of the parent transaction (Success or Failure).      |
| \_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.         |