Usage of Dynamic Schema

Dhanoop — Wed, 09 Jul 2025 05:42:55 GMT

Hi team

I have a requirement where I need to make the SQL query as dynamic.
So, I have designed the job in such a way that for SQL query I have made it as context and for schema, I have defined a single column and made the type as "Dynamic".

I am writing the output to tFileOutputExcel. I need to understand if there is any limitations in using "Dynamic" schema and in final excel file will there be any data change w.r.t what we retrieve using same query from Database.

Thanks
DBS

Re: Usage of Dynamic Schema

gvarun_arthasolutions — Sat, 29 Nov 2025 18:22:00 GMT

Hello,
You can use a context variable for SQL and a Dynamic schema, and Talend will adjust automatically.
No - Talend Dynamic does NOT modify data values.
It passes the exact row values returned by the database.
Only differences you might see:
Formatting changes (e.g., timestamp appears as string in Excel)
Excel may auto-format numbers (e.g., long integers turned into scientific notation)
Very long texts may get truncated in Excel due to Excel cell limit (~32,767 chars)
But the data content itself is identical to the DB query output.

Thanks.

topic Usage of Dynamic Schema in Talend Cloud

Usage of Dynamic Schema

Re: Usage of Dynamic Schema