It would be great if metadata concerning structure of temp tables is available in a sys,view. With this information it can be possible to use temptables for csvExport etc. We wanted to use temp tables when ever we need to create a csv file on a part of a view (not all fields of a base view needs to be exported or we use a specific where clause).
Using temp files we don't need to create seperate views (which also cannot be multi processed at the same time).
Since temp tables only exists during the lifetime of a process maybe the process id can be part of the metadata so the view can be found.
(also discussed with Matthias & Anja on Slack).
Please sign in to leave a comment.