LittlerDataflatenning fields
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with flat as (
select
*
,value as event
,value['type'] as type
from terra.core.fact_transactions,
lateral flatten( input => TX['tx_result']['events'] )
where tx_id = 'BABF2C52853529A97653EE5A201A007C84064A915C0E3CB7AFD88F2D6C2563C9'
),
dos as (
select
get(event,'attributes') as fields
from flat
)
select
fields[0]['key']
from dos
Run a query to Download Data