DiamondFast Break: Star Power Run Day One
    Updated 2024-03-02
    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