Schema Portal SQLExecutor

Could you use the SQLCreator to do this. It has a "Attributes to Expose" parameter that can be imported from the SQL query.

Hi Erik, thanks for the reply.

That wouldn't work if you are doing dynamic workspaces. If you are only opening a few datasets at a time that's fine (or the same datasets over and over again). But if you want a flexible workspace that might have to open up hundreds of different datasets then you would have to pre- expose (sounds wrong!) all of those attributes. Also the query cant expose the correct attributes if you are opening up different data sets per workspace run.

OK, I see what you are trying to do.

And a schema port would make sense on any transformer that needs exposing attributes after use (SQLExecutor, SQLCreator, Joiner etc.).

You got my vote!

I would rename the topic to "Schema output port on SQLExecutor".

This would make it easier. Note if you want to dynamically write all attributes to a dynamic writer, you can use the Custom transformer SchemaSetter, then set the Schema Sources on the writer to "Schema From Schema Feature", the only issue (I have found) is the attributes will be sorted.