Creating temporary/Session specific tables in SingleStore

[niyatisheth]

Hello ! We are exploring using SingleStore/SpeedyStore in our product solution based on SAS Viya. We plan to use SAS/Access libname to connect to the SingleStore database.

The question is how do I create a temporary/session specific table (so that it is seen and read only in that session ) within singlestore so that there is no data movement.

libname y s2 user=<user> server=<server> database=<db> port=<port>;

if I create a table using y as the libref , the below code creates a permanent table.

data y.temp;

set y.cars;

run;

My aim is to create and work on a series of temporary tables using data steps and proc sqls till I achieve my final output table.

Thanks for helping. 

[LinusH · Accepted solution]

Try the DBMSTEMP= libname option:

https://documentation.sas.com/doc/da/pgmsascdc/v_065/acreldb/p0he4t6yjfmkhpn16qrf0cdhllu6.htm