flipside

    2
    datavortex2
    Updated 2025-03-28
    SELECT distinct event_name FROM avalanche.core.ez_decoded_event_logs where event_name ilike '%import%'


    /*
    SELECT
    PARSE_JSON(metadata):sourceChain::string AS source_chain,
    PARSE_JSON(metadata):importedInputs[0].txID::string AS tx_id,
    PARSE_JSON(metadata):importedInputs[0].input.amount::number AS amount,
    PARSE_JSON(metadata):importedInputs[0].assetID::string AS asset_id,
    PARSE_JSON(metadata):importedInputs[0].outputIndex::number AS output_index
    FROM external.avalanche.fact_x_transactions
    WHERE type = 'ImportTx';
    */
    /*
    SELECT
    PARSE_JSON(metadata):sourceChain::string AS source_chain,
    PARSE_JSON(metadata):importedInputs[0].txID::string AS tx_id,
    PARSE_JSON(metadata):importedInputs[0].input.amount::number AS amount,
    PARSE_JSON(metadata):importedInputs[0].assetID::string AS asset_id,
    PARSE_JSON(metadata):importedInputs[0].outputIndex::number AS output_index
    FROM external.avalanche.fact_x_transactions
    WHERE type = 'ImportTx';
    AND transaction_hash = 'snqektrMjNapFU4XfTc5QAWNg3dS5nfruUe669gbhNSbHrJfE'
    */
    Last run: 3 months ago
    EVENT_NAME
    1
    		ImportValidator
    2
    		ImportSyncCommitteeRoot
    3
    		AvoDSAImport
    4
    		ImportBlock
    5
    		NextSyncCommitteeImported
    6
    		AvoImport
    7
    		FinalizedHeaderImported
    7
    154B
    79s