Auto refresh of guess schema

Not applicable

Auto refresh of guess schema

Is there any possibility to make guess schema in retrieve schema automatically refresh for every run of the job. If the new fields are added in database , then every time we need to open the job and has to click guess schema. In order to avoid this is there any other possibility?
One Star

Re: Auto refresh of guess schema

Is there any possibility to make guess schema in retrieve schema automatically refresh for every run of the job. If the new fields are added in database , then every time we need to open the job and has to click guess schema. In order to avoid this is there any other possibility?

Not so easy, and depends on overall job design. Please search for "dynamic schema" on the forum, the are lot of discussions (https://www.talendforge.org/forum/search.php?search_id=1683024686)
Six Stars

Re: Auto refresh of guess schema

Hi,
In your job, when you create a query, the result go to the next composant with a row. In this row, you have your schema.
This schema can't use all table fields so it's difficult to have an option like this.
Today, you must open your project, modify your schema through your metadata and apply to your jobs.
Arnaud
Six Stars

Re: Auto refresh of guess schema

'Dynamic schema' feature is available is TOS Commercial version. Else, you have to set schema manually.
Arnaud