My goal is to get schema attributes to save to a csv file that I can then use to setup my feature writer user attributes. I am struggling to get anything to work.
Every sql I try returns errors, I have tried sql creator and sql executor with no success.
I have my sql working now, I have created my csv file
Now I am struggling to get my writer to work
I have added the csv as a workspace resource using 'schema from table'
I have my sql working now, I have created my csv file
Now I am struggling to get my writer to work
I have added the csv as a workspace resource using 'schema from table'
The CSV writer doesn't know what to do with the Oracle "schema", you need to supply the schema as an attribute list, see https://knowledge.safe.com/articles/1051/index.html
Try inserting a SchemaSetter (from the FME Hub) before the writer, the custom transformer will create the schema attribute list for you.