Events show up on the Event Browser, but I cannot see them in (SQL) Data Explorer

Unity Services
,
1

I am trying to create charts based off some of the data I’ve collected on my Unity game. On this image, you can see that my analytics are being collected on the Event Browser.

However, when I go to the Data Explorer or the SQL Data Explorer to make use of the data, I cannot seem to fetch any data.

For example, if I use this code on the SQL Data Explorer:

SELECT 
    EVENT_TIMESTAMP, 
    EVENT_NAME, 
    USER_ID
FROM EVENTS
WHERE EVENT_NAME IN ('gameStarted', 'gameEnded', 'clientDevice', 'sdkStart')
ORDER BY EVENT_TIMESTAMP DESC;

I see that no data appears, even though the Event Browser clearly shows that the data exists.

I am new to Unity Analytics. Am I doing something wrong here?

2

Hi,

Your SQL query looks fine. I wonder if it might just have been the data refresh cadence catching you out.

How long after sending your events and viewing them in the Event Browser did you wait before running the SQL Data Explorer query?

How long does it take before my data shows in the dashboard? After the SDK installation, it can take a minimum of one hour for the metrics to be processed for analysis in the dashboards and Data Explorer. To confirm your integration is successful, use the Event Browser to view your event stream.

If you are still unable to see your events in the SQL Data Explorer, please submit an Analytics Support Ticket and let us know your ProjectID, and we will be able to investigate further.

3

At the time of me writing my original post, it has been several hours since I’ve waited.

However, I have tried again this morning with the same exact SQL query, and the data has now started appearing.

Thank you for your time.

1 Like