WITH res AS (

SELECT

livequery.live.udf_api(

'GET',

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

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

{ 'sheets_id': '1q_gCPbfXEqb3_7PiYmXM0aYV0KqJLAPXIbyIAPQ6tMk',

'tab_name': 'WI:Disney' }

) AS result

FROM

DUAL

),

flattened_data AS (

SELECT

TO_TIMESTAMP_NTZ(f.value:"Timestamp") AS "Timestamp",

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

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

WHEN f.value:"Render" LIKE 'OEV1-PRIN-BELL%' THEN CONCAT('Belle', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-CIND%' THEN CONCAT('Cinderella', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-MULA%' THEN CONCAT('Mulan', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-JASM%' THEN CONCAT('Jasmine', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-MOAN%' THEN CONCAT('Moana', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-SNOW%' THEN CONCAT('Snow White', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-ARIE%' THEN CONCAT('Ariel', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-TIAN%' THEN CONCAT('Tiana', ' - ', f.value:"Variant")

WHEN f.value:"Render" LIKE 'OEV1-PRIN-RAPU%' THEN CONCAT('Rapunzel', ' - ', f.value:"Variant")

ELSE CONCAT(f.value:"Render", ' - ', f.value:"Variant")

END AS "Render - Variant",

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

f.value:"Total Minted" :: NUMBER AS "Total Minted",

f.value:"Total Burned" :: NUMBER AS "Total Burned",