Hi, I´m really new using nifi and Data ingestion. I´m trying to get data from Oracle database using Nifi and put data into Yugabyte database tables.
1.- Nifi get data information from ETL table 2.- Nifi put data into ETL Yugabyte table 3.- Yugabyte table puts ETL data information in Master table using trigger.
This is working good, my question is about how can I handle the schema changes in data ingestion?, for example, if I add a new column in ETL table on oracle table how can I manage it to make this change on yugabyte side? Current I have to stop nifi, wait to queue is clear then add the column in yugabyte ELT and Master table and finally start nifi again.