create or replace table `reby-cloud.analytics_reby_v1_eu.pg_topups_json` as select id, created_at, gateway, gateway_transaction_id, stripe_charge_id, array(select as struct value_amount as amount, value_currency as currency) as value, array(select as struct original_value_amount as amount, original_value_currency as currency) as original_value, user_id, company_id, braintree_transaction_id from `reby-cloud.staging_eu.pg_topups_stg`
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter