availabilty of metadata on temp tables

Follow

0

Don Seur

• February 13, 2019 13:55

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 actions Permalink

  Official comment

  

  Salvatore Raunich

  • February 13, 2019 15:18

  Hi Don,

  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.

  Best

  Salvatore 

Please sign in to leave a comment.