Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Table Output with headers

How Text Output component is able to add headers in files placed on S3? (SQL tab of component shows SQL not generated)

3 Community Answers

Matillion Agent  

Ian Funnell —

Hi Rahul,

It’s able to do this because it uses JDBC rather than a SQL command.. which is why you do’t see the generated SQL statement in this case.

Best regards,
Ian


Rahul Monga —

Hi Ian,

I have query about JDBC handling the case when column type in table is numeric/date.
I am assuming that header row is appended to original file before output is placed on S3.
So while appending to table, do text output casts the datatype of all columns.

Thanks,
Rahul


Matillion Agent  

Ian Funnell —

Hi Rahul,

You’re right, yes: the header is written first and then the output rows later while the file is being built up in S3.

There is a default format mask for all datatypes, to write them out as a String. If you want more explicit control then you could create a view over the data, and in the view convert all the non-string datatypes to string, with your own choice of format mask.

Best regards,
Ian

Post Your Community Answer

To add an answer please login