WITH res AS (

SELECT

livequery.live.udf_api(

'GET',

'https://science.flipsidecrypto.xyz/googlesheets/readsheet',

{ 'Content-Type': 'application/json' },

{ 'sheets_id': '11JorTifhZl-3I6RKt6JCHsxJHed6QOMCZGWRbQ6Ai6w',

'tab_name': 'AUG' }

) AS result

FROM

DUAL

),

total_row_count AS (

SELECT

COUNT(*) AS "TotalRows"

FROM

res,

LATERAL FLATTEN(input => TRY_PARSE_JSON(res.result:data)) f

),

processed_data AS (

SELECT

f.value:"Timestamp" :: VARCHAR AS "Timestamp",

f.value:"Username" :: VARCHAR AS "Username",

f.value:"Wallet Address" :: VARCHAR AS "Wallet Address",

f.value:"momentID" :: NUMBER AS "momentID",

f.value:"Points" :: NUMBER AS "Points",

f.value:"Player" :: VARCHAR AS "Player",

f.value:"Team" :: VARCHAR AS "Team",

f.value:"Play Type" :: VARCHAR AS "Play Type",

f.value:"Game Date" :: VARCHAR AS "Game Date",

f.value:"Set" :: VARCHAR AS "Set",

f.value:"Series" :: VARCHAR AS "Series",

f.value:"Serial Number" :: NUMBER AS "Serial Number",

f.value:"Tier" :: VARCHAR AS "Tier",