DiamondFast Break: Star Power Run Day One
Updated 2024-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH res AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{
'sheets_id' : '1UXVqNiCw3LdXuoSn1XIbbMDIq7ct3X397h84PgbiEPk',
'tab_name' : 'dayone'
}
) AS result
FROM DUAL
),
flattened_data AS (
SELECT
f.value:"Rank"::NUMBER AS "Rank",
f.value:"Points"::NUMBER AS "Points",
f.value:"Username"::VARCHAR AS "Username",
f.value:"Result"::VARCHAR AS "Result",
f.value:"P1"::VARCHAR AS "P1",
f.value:"P1Points"::NUMBER AS "P1_Points",
f.value:"P2"::VARCHAR AS "P2",
f.value:"P2Points"::NUMBER AS "P2_Points",
f.value:"P3"::VARCHAR AS "P3",
f.value:"P3Points"::NUMBER AS "P3_Points",
f.value:"P4"::VARCHAR AS "P4",
f.value:"P4Points"::NUMBER AS "P4_Points",
f.value:"P5"::VARCHAR AS "P5",
f.value:"P5Points"::NUMBER AS "P5_Points",
f.value:"PlayerUsage"::VARCHAR AS "Player Usage",
f.value:"Count"::NUMBER AS "Player Usage Count"
FROM res,
LATERAL FLATTEN(input => TRY_PARSE_JSON(res.result:data)) f
),
QueryRunArchived: QueryRun has been archived