SELECT

*

FROM

(

VALUES

('Ethereum', '1', 'ETH'),

('Arbitrum', '42161', 'ETH'),

('BNB Smart chain', '56', 'BNB'),

('Avalanche_C', '43114', 'AVAX'),

('Optimism ', '10', 'ETH'),

('Polygon', '137', 'MATIC'),

('BASE', '8453','ETH'),

('Gnosis', '100', 'XDAI'),

('zkSync Mainnet', '324', 'ETH'),

('Solana', '1151111081099710','SOL'),

('Fantom Opera', '250','FTM'),

('Polygon zkEVM', '1101','ETH'),

('Linea', '59144', 'ETH'),

('Aurora','1313161554','AURORA')

) AS a (chain, dest_chain_id,currency)

,

polygon_chain_data as (

SELECT

'polygon' as src_chain ,

a.block_timestamp,

a.tx_hash,

a.origin_from_address,

decoded_log:toChainId AS dest_chain_id,

decoded_log:amount as amount_raw,

decoded_log:token as asset_id

FROM polygon.core.ez_decoded_event_logs a

join (

select