SELECT

*,

'arbitrum' as chain

FROM

arbitrum.core.fact_decoded_event_logs

UNION

ALL

SELECT

*,

'optimism' as chain

FROM

optimism.core.fact_decoded_event_logs

UNION

ALL

SELECT

*,

'base' as chain

FROM

base.core.fact_decoded_event_logs

UNION

ALL

SELECT

*,

'ethereum' as chain

FROM

ethereum.core.fact_decoded_event_logs

UNION

ALL

SELECT

*,

'polygon' as chain

FROM

polygon.core.fact_decoded_event_logs

),

fact_tx as (