https://community.qlik.com/t5/Talend-Studio/Compare-database-table-schema-before-and-after-metadata-update/m-p/2342683#M110517 <P>Hello, </P><P>assume we have a defined database table "a" schema (col1 numeric, col2 numeric, col3 numeric).</P><P>Now the source table "a" gets modified in the source system, so i have to update metadata in Talend Studio via "Edit Schema" -&gt; "Retrieve Schema"</P><P>The schema itself gets updated, but how can i see the actual changes before and after updating, so that i can make the adjustments in the job accordingly?</P><P>Currently i need to ask the datasource owner what the changes were (new column added, changed datatype, removed column)</P><P>Q1: Is there any way to compare old and new schema?</P><P>Q2: Any possibilty to see how the schema update affects existing jobs and components, so i can work through all single jobs step-by-step?</P> Wed, 18 Jan 2023 14:22:42 GMT Anonymous 2023-01-18T14:22:42Z https://community.qlik.com/t5/Talend-Studio/Compare-database-table-schema-before-and-after-metadata-update/m-p/2342683#M110517 <P>Hello, </P><P>assume we have a defined database table "a" schema (col1 numeric, col2 numeric, col3 numeric).</P><P>Now the source table "a" gets modified in the source system, so i have to update metadata in Talend Studio via "Edit Schema" -&gt; "Retrieve Schema"</P><P>The schema itself gets updated, but how can i see the actual changes before and after updating, so that i can make the adjustments in the job accordingly?</P><P>Currently i need to ask the datasource owner what the changes were (new column added, changed datatype, removed column)</P><P>Q1: Is there any way to compare old and new schema?</P><P>Q2: Any possibilty to see how the schema update affects existing jobs and components, so i can work through all single jobs step-by-step?</P> Wed, 18 Jan 2023 14:22:42 GMT https://community.qlik.com/t5/Talend-Studio/Compare-database-table-schema-before-and-after-metadata-update/m-p/2342683#M110517 Anonymous 2023-01-18T14:22:42Z