from terra.core.fact_msg_attributes where msg_type = 'create_validator' and attribute_key = 'validator')

select

tx_sender , TX:body:messages[0]:validator_address::string as vadd

,TX:body:messages[0]:commission:rate as commission_rate

from terra.core.fact_transactions a join creat_tx b on a.tx_id = b.tx_id