from

cosmos.core.fact_msg_attributes

when MSG_TYPE in ('submit_proposal','edit_validator','proposal_vote') then 'governance'

when MSG_TYPE in ('ibc_transfer','coin_received') then 'transfer'

when MSG_TYPE in ('redelegate','delegate') then 'staking'

when MSG_TYPE in ('swap_within_batch') then 'swapping'

end as action,

else other