Hi There, Is there a way we can compare just the table/view for structural differences between two environments. I am not looking to compare the data just trying to see any metadata differences exists for ex. column names, datatype, length, Primary Key etc. I don’t want to bring the data as it is time consuming and not the intent of this exercise.
Thank you so much. I am new to this tool and just getting started. Once I configure the Extract Table Spec node, should I be using the Compare Node to find the differences ? Is there a way you can provide a sample workflow to showcase this functionality? It will be very helpful to understand the end-to-end workflow.
As you can see this is the information that you can get from the table. I’ve introduced one difference in column name (@index0) and format type (@index3)… Then i solved to compare with a full outer join; with matching columns: Column Name, Column Type and Column Index (Position).
@gonhaddock Thanks a bunch for your help and I managed to pull this off and created my first workflow!
Couple of follow-ups:
I noticed that Extract Table Spec doesn’t bring the column size or length. Is there a way we can pull this?
My another use case is to compare the view definition(the actual DDL) between two environments. I doubt this can be achieved and I do understand this may not be an ideal use case/functionality for KNIME. But just wanted to check.