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

*,

'bnb' as chain

FROM

bsc.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