We are currently seeing a significant slowdown in querying data related to our game in Snowflake and are trying to find the cause.
Our query which references the PLAYFAB_SHARED database used to run in ~1minute over the last couple of weeks, but as of yesterday, the same query runs for >15+ minutes without completion and without any change in the size of the data queried.
Further context: we create a replica of our game's data for the previous 7 days (copying from the PLAYFAB_SHARED database into our own database) in order to run further queries at a faster speed, without having to access the PLAYFAB_SHARED database for each query. Our game is currently in soft launch and records ~300k events over a 7-day period (~50MB of data).
The specific query we use is:
select *
from PLAYFAB_SHARED.PLAYFAB_SHARED.PLAYFAB_ARCHIVE_SHARED
WHERE title_id = 'A0D3'
AND ts >= dateadd(days, -7, current_date)
AND ts < current_date
Any ideas on what we should be looking at to investigate the reason for the slowdown in the query would be great.
Thanks