availabilty of metadata on temp tables
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).
Comment actionsOfficial comment
thanks for posting this feature request.
At the moment metadata of temporary tables is available only internally and it is not exposed to the clients, but we understand the need for it -- also internally for the development of our SQL connectors -- and we will look into it.
Please sign in to leave a comment.