| hash | VARCHAR(16777216) | Unique identifier of a transaction. |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| sender_address | VARCHAR(16777216) | The address of the account that sent the transaction. |
| nonce | NUMBER(38,0) | The transaction nonce, unique to the wallet |
| type | VARCHAR(16777216) | The type of transaction |
| execution_status | VARCHAR(16777216) | The execution status of the transaction |
| finality_status | VARCHAR(16777216) | The finality status of the transaction |
| messages_sent | VARIANT | Array of messages sent by this transaction. |
| revert_reason | VARCHAR(16777216) | The reason for transaction revert, if applicable. |
| receipt_type | VARCHAR(16777216) | The type of transaction receipt. |
| account_deployment_data | VARIANT | Data related to account deployment, if this is a deploy transaction. |
| calldata | VARIANT | The calldata passed to the transaction. |
| paymaster_data | VARIANT | Data related to paymaster functionality, if used. |
| actual_fee_amount | NUMBER(38,0) | The actual fee amount paid for the transaction. |
| actual_fee_unit | VARCHAR(16777216) | The unit of the actual fee (e.g., ‘WEI’, ‘FRI’). |
| receipt_l1_data_gas | NUMBER(38,0) | The L1 data gas consumed by this transaction. |
| receipt_l1_gas | NUMBER(38,0) | The L1 gas consumed by this transaction. |
| receipt_l2_gas | NUMBER(38,0) | The L2 gas consumed by this transaction. |
| max_fee | NUMBER(38,0) | The maximum fee the sender is willing to pay. |
| l1_data_gas_max_amount | NUMBER(38,0) | The maximum L1 data gas amount the sender is willing to consume. |
| l1_data_gas_max_price_per_unit | NUMBER(38,0) | The maximum price per unit for L1 data gas. |
| l1_gas_max_amount | NUMBER(38,0) | The maximum L1 gas amount the sender is willing to consume. |
| l1_gas_max_price_per_unit | NUMBER(38,0) | The maximum price per unit for L1 gas. |
| l2_gas_max_amount | NUMBER(38,0) | The maximum L2 gas amount the sender is willing to consume. |
| l2_gas_max_price_per_unit | NUMBER(38,0) | The maximum price per unit for L2 gas. |
| signature | VARIANT | The cryptographic signature authorizing the transaction, format varies based on the account type (EOA vs smart contract wallet). |
| tip | NUMBER(38,0) | The tip amount paid to the sequencer. |
| fee_data_availability_mode | VARCHAR(16777216) | The data availability mode for fee payment. |
| nonce_data_availability_mode | VARCHAR(16777216) | The data availability mode for nonce. |
| class_hash | VARCHAR(16777216) | The hash of the contract class being declared or deployed. |
| contract_address | VARCHAR(16777216) | The address of the deployed contract, if applicable. |
| contract_address_salt | VARCHAR(16777216) | The salt used for contract address calculation. |
| constructor_calldata | VARIANT | The calldata passed to the constructor during deployment. |
| entry_point_selector | VARCHAR(16777216) | The entry point selector for the function being called. |
| compiled_class_hash | VARCHAR(16777216) | The hash of the compiled contract class. |
| version | NUMBER(38,0) | The transaction version. |
| event_count | NUMBER(38,0) | Number of events emitted by this transaction. |
| l1_message_count | NUMBER(38,0) | Number of L1 messages sent by this transaction. |
| l2_message_count | NUMBER(38,0) | Number of L2 messages sent by this transaction. |
| block_hash | VARCHAR(16777216) | Unique identifier of the block that includes this transaction. |
| block_number | NUMBER(38,0) | The length of the chain, in blocks. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
