Links

Beta Migration Guide

Summary of changes:
  • All chain data has been reprocessed and reported data quality issues have been fixed (i.e. missing or incorrect decoded data, added "0-padding" for decoded arguments in calls and events)
  • RAW and DECODED schemas are no longed necessary. All tables are available in a single database schema.
  • Raw and decoded tables have been merges into single tables for all entities.
  • Traces table has been renamed to Calls to keep consistency with the multi-chain data model.
  • Two separate status columns have been added to flag the status of the decoding processes:
    • decoded - Flags the success (true) or failure (false) of the decoding process. Exact definition depends on each record type.
    • processed - defines processing status of a record by the decoding ETL process.
  • Data set includes reverted transactions. These can be easily identified via the reverted column in the transactions table.
  • Columns have been renamed, removed or added across all tables. Specific details and mapping to the new column are provided for each table to facilitate changing queries.

Changes in the data model

Once you have moved the new database you can follow the details below to update your queries. Make sure that you also update the name of the database and the schema. Need help? Reach out to our team.

Blocks

New columns

Column Name
Data Type
Layer
Definition
updated_at
timestamp
TECH
Technical field. Timestamp of the ETL process that has updated the row in the table. Equal to loaded_at on first insert.
block_id
varchar
TECH
Technical field. Identifier of the block across chains and generation, constructed by concatenating chain_id, generation and block number.
block_date
varchar
TECH
Technical field. Date of the block - precomputed to be used for analytics purposes, inherited by calls, events, transactions and diffs happening in the same block.
protocol_version
varchar
RAW
Version of the chain that was live at the moment when the node was added to the chain. For details about Starknet version see the official release notes: https://docs.starknet.io/documentation/starknet_versions/version_notes/
processed
boolean
TECH
Technical field. Defines processing status of a block by the decoding ETL process.

Existing columns

Schema - SDW BETA
Column - SDW BETA
Column - MCDW Starknet
Changes & Comments
RAW
block_hash
block_hash
RAW
block_number
block_number
RAW
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
RAW
gas_price
gas_price
RAW
load_id
loaded_at
Renamed
RAW
parent_hash
parent_hash
RAW
sequencer
sequencer_address
Renamed
RAW
state_root
state_root
RAW
timestamp
block_timestamp
Renamed
RAW
tx_count
tx_count
DECODED
block_hash
block_hash
DECODED
block_number
block_number
DECODED
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
DECODED
gas_price
gas_price
DECODED
load_id
loaded_at
Renamed
DECODED
parent_hash
parent_hash
DECODED
sequencer
sequencer_address
Renamed
DECODED
state_root
state_root
DECODED
timestamp
block_timestamp
Renamed
DECODED
tx_count
tx_count

Transactions

New columns

Column Name
Data Type
Layer
Definition
updated_at
timestamp
TECH
Technical field. Timestamp of the ETL process that has updated the row in the table. Equal to loaded_at on first insert.
block_id
varchar
TECH
Technical field. Identifier of the block across chains and generation, constructed by concatenating chain_id, generation and block number.
block_date
varchar
TECH
Technical field. Date of the block - precomputed to be used for analytics purposes, inherited by calls, events, transactions and diffs happening in the same block.
tx_id
varchar
TECH
Technical field. Identifier of the transaction, constructed by concatenating block id and transaction index, separated by underscores.
function_signature
varchar
RAW
Binary signature of the called function. 0x in case of pure Ether transfers.
class_hash
varchar
RAW
Hash of the contract class definition (KECCAK-256).
tx_value
number
RAW
Ether amount transferred, in WEI. Value must be divided by 10^18 to obtain Ether amount. 0 if no Ether transfer happened.
created_address
varchar
RAW
Address of created contract.
reverted
boolean
RAW
Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic.
revert_reason
varchar
RAW
Error description for reverted transactions, as provided by the smart contract. Empty for successful transactions.
execution_resources
json
RAW
Resources consumed by the transaction execution.
processed
boolean
TECH
Technical field. Defines processing status of a block by the decoding ETL process.

Existing columns

Schema - SDW BETA
Column - SDW BETA
Column - MCDW Starknet
Changes & Comments
RAW
actual_fee
actual_fee
RAW
block_number
block_number
RAW
call_data
-
Removed
RAW
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
RAW
class_hash
class_hash
RAW
contract
to_address
Renamed
RAW
contract_salt
-
Removed
RAW
entry_point_selector
-
Removed
RAW
entry_point_type
-
Removed
RAW
execution_resources
execution_resources
RAW
load_id
loaded_at
Renamed
RAW
max_fee
max_fee_per_gas
Renamed
RAW
nonce
nonce
RAW
signature
-
Removed
RAW
timestamp
block_timestamp
Renamed
RAW
tx_hash
tx_hash
RAW
tx_index
tx_index
RAW
type
tx_type
Renamed
RAW
version
-
Removed
DECODED
actual_fee
actual_fee
DECODED
block_number
block_number
DECODED
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
DECODED
class_hash
class_hash
DECODED
contract
to_address
Renamed
DECODED
entry_point_selector
-
Removed
DECODED
entry_point_type
-
Removed
DECODED
execution_resources
execution_resources
DECODED
load_id
loaded_at
Renamed
DECODED
max_fee
max_fee_per_gas
Renamed
DECODED
nonce
nonce
DECODED
signature
-
Removed
DECODED
timestamp
block_timestamp
Renamed
DECODED
tx_hash
tx_hash
DECODED
tx_index
tx_index
DECODED
type
tx_type
Renamed
DECODED
version
-
Removed
DECODED
error
exception_error
Renamed
DECODED
function
-
Removed
DECODED
inputs
-
Removed
DECODED
l1_message_nonce
l1_message_nonce
DECODED
outputs
-
Removed

Traces

This table has been renamed to Calls

New columns

Column Name
Data Type
Layer
Definition
updated_at
timestamp
TECH
Technical field. Timestamp of the ETL process that has updated the row in the table. Equal to loaded_at on first insert.
block_id
varchar
TECH
Technical field. Identifier of the block across chains and generation, constructed by concatenating chain_id, generation and block number.
block_date
varchar
TECH
Technical field. Date of the block - precomputed to be used for analytics purposes, inherited by calls, events, transactions and diffs happening in the same block.
tx_id
varchar
TECH
Technical field. Identifier of the transaction, constructed by concatenating block id and transaction index, separated by underscores.
call_depth
number
TECH
Depth of the call in the transaction execution tree, incremental, starting at 0 for top level calls (call_path='0_2_1' depth= 3 means three level down in the execution tree).
call_value
number
RAW
Ether amount transferred, in WEI. Division by 10^18 to obtain Ether amount. 0 if no Ether transfer happened.
created_address
varchar
RAW
Created address in the case of 'CREATE' call. NULL for any other call type.
processed
boolean
TECH
Technical field. Defines processing status of a block by the decoding ETL process.
decoded
boolean
TECH
Technical field. Flags the success (true) or failure (false) of the decoding process. In the case of unsucessful decoding, function_signature = function_name

Existing columns

Schema - SDW BETA
Column - SDW BETA
Column - MCDW Starknet
Changes & Comments
RAW
block_number
block_number
RAW
caller
from_address
Renamed
RAW
call_data
call_data
RAW
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
RAW
class_hash
class_hash
RAW
contract
to_address
Renamed
RAW
entry_point_selector
function_signature
Renamed
RAW
entry_point_type
function_type
Renamed
RAW
execution_resources
execution_resources
RAW
invocation_type
invocation_type
RAW
load_id
loaded_at
Renamed
RAW
results
return_data
Renamed
RAW
timestamp
block_timestamp
Renamed
RAW
trace_path
call_path
Renamed
RAW
trace_type
call_type
Renamed
RAW
tx_hash
tx_hash
DECODED
block_number
block_number
DECODED
caller
from_address
Renamed
DECODED
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
DECODED
contract
to_address
Renamed
DECODED
entry_point_selector
function_signature
Renamed
DECODED
entry_point_type
function_type
Renamed
DECODED
execution_resources
execution_resources
DECODED
invocation_type
invocation_type
DECODED
load_id
loaded_at
Renamed
DECODED
timestamp
block_timestamp
Renamed
DECODED
trace_path
call_path
Renamed
DECODED
trace_type
call_type
Renamed
DECODED
tx_hash
tx_hash
DECODED
function
function_name
Renamed
DECODED
inputs
arguments
Renamed
DECODED
outputs
outputs
DECODED
trace_id
call_id
Renamed

Events

New columns

Column Name
Data Type
Layer
Definition
updated_at
timestamp
TECH
Technical field. Timestamp of the ETL process that has updated the row in the table. Equal to loaded_at on first insert.
block_id
varchar
TECH
Technical field. Identifier of the block across chains and generation, constructed by concatenating chain_id, generation and block number.
block_date
varchar
TECH
Technical field. Date of the block - precomputed to be used for analytics purposes, inherited by calls, events, transactions and diffs happening in the same block.
tx_id
varchar
TECH
Technical field. Identifier of the transaction, constructed by concatenating block id and transaction index, separated by underscores.
implementation
varchar
RAW
Smart contract address that provides the event semantics (ABI) - called contract for DELEGATE calls or calling contract for the rest of the call types.
event_signature
varchar
RAW
Raw hexadecimal indexed content of the event (topic 0).
event_name
varchar
DECODED
Name of the event, as decoded by Token Flow processes (ABI or inferred from similar functions). Contains event_signature if not found.
processed
boolean
TECH
Technical field. Defines processing status of a block by the decoding ETL process.
decoded
boolean
TECH
Technical field. Flags the success (true) or failure (false) of the decoding process. In the case of unsucessful decoding, event_signature = event_name

Existing columns

Schema - SDW BETA
Column - SDW BETA
Column - MCDW Starknet
Changes & Comments
RAW
block_number
block_number
RAW
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
RAW
class_hash
class_hash
RAW
contract
contract_address
Renamed
RAW
data
log_data
Renamed
RAW
event_order
log_index
Renamed
RAW
keys
topics
Renamed
RAW
load_id
loaded_at
Renamed
RAW
timestamp
block_timestamp
Renamed
RAW
trace_path
-
Renamed
RAW
tx_hash
tx_hash
DECODED
block_number
block_number
DECODED
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
DECODED
class_hash
class_hash
DECODED
contract
contract_address
Renamed
DECODED
event_order
log_index
Renamed
DECODED
keys
-
Removed. Replaced by event_signature (topic0)
DECODED
load_id
loaded_at
Renamed
DECODED
tx_hash
tx_hash
DECODED
event_id
event_id
DECODED
name
event_name
Renamed
DECODED
parameters
parameters
DECODED
trace_id
call_id
Renamed

Messages

New columns

Column Name
Data Type
Layer
Definition
updated_at
timestamp
TECH
Technical field. Timestamp of the ETL process that has updated the row in the table. Equal to loaded_at on first insert.
block_id
varchar
TECH
Technical field. Identifier of the block across chains and generation, constructed by concatenating chain_id, generation and block number.
block_date
varchar
RAW
Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block.
tx_id
varchar
TECH
Technical field. Identifier of the transaction, constructed by concatenating block id and transaction index, separated by underscores.
message_id
varchar
TECH
Unique identifier of the message.
message_source
varchar
TECH
Source of the message: it can be L1 or L2
message_nonce
number
RAW
Nonce of the message from L1 to L2
processed
boolean
TECH
Technical field. Defines processing status of a block by the decoding ETL process.
decoded
boolean
TECH
Technical field. Flags the success (true) or failure (false) of the decoding process.

Existing columns

Schema - SDW BETA
Column - SDW BETA
Column - MCDW Starknet
Changes & Comments
RAW
block_number
block_number
RAW
chain_id
chain_id
Change in logic and data type. Value for Starknet is "5461067"
RAW
class_hash