Memory-only tables are not persisted by default like a regular table. You can add, modify, or delete records in a memory-only table.
Memory-only tables have the same naming criteria and name resolution as persisted tables.
The following scenarios/endpoints will create a memory-only table (unless persistence is specified):
result_table
option specifiedis_result_table
option set to true
All memory-only table types listed above copy data from their source data sets, thus their memory footprint can be quite large compared to a join view or a filtered view. However, because the data is copied, there's no reliance on lookups between connected join data sets or scanning mask on filtered data sets, resulting in faster queries.