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)

2 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,

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.


Post Your Community Answer

To add an answer please login