Search Unity

  1. We are migrating the Unity Forums to Unity Discussions. On July 12, the Unity Forums will become read-only.

    Please, do not make any changes to your username or email addresses at id.unity.com during this transition time.

    It's still possible to reply to existing private message conversations during the migration, but any new replies you post will be missing after the main migration is complete. We'll do our best to migrate these messages in a follow-up step.

    On July 15, Unity Discussions will become read-only until July 18, when the new design and the migrated forum contents will go live.


    Read our full announcement for more information and let us know if you have any questions.

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:
    14
    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:
    14
    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:
    83
    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!