Search Unity

  1. Megacity Metro Demo now available. Download now.
    Dismiss Notice
  2. Unity support for visionOS is now available. Learn more in our blog post.
    Dismiss Notice

Bug SQL Data Explorer - Missing Data To CSV

Discussion in 'Unity Analytics' started by LuftetarMan, Jun 7, 2022.

  1. LuftetarMan

    LuftetarMan

    Joined:
    Sep 25, 2015
    Posts:
    12
    Hello

    When i run query like this select * from EVENTS where EVENT_DATE >'2022-05-25' i get many(data by 8 tester i mean not that big data) data and i save it as CSV file then i notice there are some datas missing in CSV when i check in local. I can't check with CTRL+F in SqlDatExplorer page in listview because many data there. After i simplified my query for specific data then i dont see any data missing.

    And same query each time CSV file size different. Bigger ok maybe at first sight but smaller too. But im pretty sure that some data missing that i mentioned above. i dont know maybe this can be reason the CSV file is created from listview source , not from server.

     
  2. JeffDUnity3D

    JeffDUnity3D

    Joined:
    May 2, 2017
    Posts:
    14,446
    Thank you for the report. Can you clarify which data is missing, perhaps share a screenshot? How did you simplify the query? Keep in mind we are continually processing data so numbers between queries may indeed be different (larger)
     
  3. LuftetarMan

    LuftetarMan

    Joined:
    Sep 25, 2015
    Posts:
    12
    Simplify i meant that to able to check specific data is there or not.

    Some data are missing in BEFORE . But some data(except 61) is OK in AFTER. And when i use SqlDataExplorer 61 is there. I import CSV into Sqlite Studio. 61 is also missing when I checked CSV with LibreOffice Calc and NotePad++ .


    All.PNG
     
  4. unity_Ctri

    unity_Ctri

    Unity Technologies

    Joined:
    Oct 20, 2020
    Posts:
    81
    Hi Lufetar,

    Thanks for reporting this, that's very strange. I'd like to take a look at it in greater detail.
    Can you DM me your project ID? You can find it from the URL in your browser, for example one of my test projects looks like this:

    https://dashboard.unity3d.com/organizations/9071180744788/projects/69b6409a-8dd8-4f59-5cd5-fa4a2fd65239/environments/eea0330e-2668-4901-99e8-2980e160e524/analytics/v2/sql-data-explorer

    Cheers!