I've set up snowflake and can successfully run the query I need using their web interface; but I'm not quite sure how to initiate the query, and use it's results, from a scheduled cloud script. I figured I'd be able to use snowflake's node.js SDK, but it seems cloud scripts do not use node.js (?).
The following is the query in question:
select
p:levelSeed as levelSeed,
coalesce(count(case when p:result = 'didWin' then 1 end), 0) as winCount,
coalesce(count(case when p:result = 'didLose' then 1 end), 0) as loseCount,
coalesce(count(case when p:result = 'didQuit' then 1 end), 0) as quitCount
from PLAYFAB_SHARED.PLAYFAB_SHARED.PLAYFAB_ARCHIVE_SHARED
where event_namespace = 'title.[myTitleID]' and event_name = 'player_completed_game'
group by levelSeed
Am I overlooking something in the server API (or elsewhere) that allows me to query my snowflake add-on in a cloud script?
Any suggestions would be appreciated, thanks.