All the data that InSights Into Data works with is held in In-Memory tables. When you run a query or import a file - then this data is retrieved from the database or file and put into In-Memory tables. It is these tables that the other parts of the Query work on.
When you define the query (in this example the SQL) - you also note for that particular SQL of the Query (there can be multiple SQL or import texts for each Query) you give it a name. In the example below - the Analysis: Order Analysis query has a Results Table Name of Analysis. This is REALLY important to note - as any Reports or Dashboards will reference that exact name. If you change the name - you will have to update anything that refers to it!!
As well - if you run a Query that has a Results Table Name of say 'TableX' - but another query has been run that already created the in-memory table of that name - then the program will create a unique name of you of 'TableX1'. It will increment the number until a unique name is found. This is Important - because it may impact your Reports, Dashboards, etc..
It is important to note one restriction in InSights Into Data, and that is each in-memory table is restricted to just a little over 16 Million records.
Here you can see the three in-memory tables that are currently being used. In the screen capture of the Query above - you can see the Result Table Name - and in the screen capture below you can see the in-memory table of the same name.
