Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin.raw.inputs |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, transaction_hash, index |
| Clustering Key(s) | block_timestamp::date, index |
| Search Optimization | spent_utxo_id, transaction_hash, spent_transaction_hash, address0 |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| spent_transaction_hash | VARCHAR(66) | The transaction hash of the output. |
| spent_output_index | NUMBER(38,0) | The index of the output. |
| script_asm | VARCHAR(16777216) | The script public key in the form of string, |
| script_hex | VARCHAR(16777216) | Hexadecimal representation of the bitcoin’s script language op-codes. |
| sequence | NUMBER(38,0) | The sequence number of the script. |
| txinwitness | VARIANT | Array of witness data items for this input, as introduced by SegWit. Each item is a hex-encoded byte string. |
| coinbase | VARCHAR(16777216) | Whether this transaction is a coinbase transaction (the first transaction in a block that awards the block subsidy and transaction fees to the miner). True for coinbase transactions, false for all others. |
| index | NUMBER(38,0) | The index of the input. |
| transaction_hash | VARCHAR(66) | Unique hash of the transaction input. |
| block_hash | VARCHAR(66) | Block hash of the transaction input. |
| block_number | NUMBER(38,0) | Block number or block height of the transaction input. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the transaction input. |
| input_id | VARCHAR(73) | Input ID generated from transaction hash and index. |
| spent_utxo_id | VARCHAR(73) | Spent UTXO ID generated from transaction hash and index. |
| type | VARCHAR(16777216) | The addres type of intput |
| addresses | VARCHAR(16777216) | The address that owned/owns the output used as input. |
| address0 | VARCHAR(130) | Index 0 of the addresses |
| value | NUMBER(38,0) | Value in BTC unnormalized. |
| value_max_exclusive | NUMBER(38,0) | sum(value of all inputs with index lesser than itself) + value - 1 within the same transaction. Used for ordinal tracking where FIFO principle is used. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| value_min_inclusive | NUMBER(38,0) | sum(value of all inputs with index lesser than itself) within the same transaction. Used for ordinal tracking where FIFO principle is used. |
| _stg_created_at | TIMESTAMP_NTZ(9) | Internal staging timestamp recording when this row was first written to the staging layer. |
| _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. |