Using GenerateTableFetch To Create ETL's In Your Dataflow | Apache Nifi | Part 9

Man, never in my life did i think i would watch a tutorial made by Seth Rogan, nice thanks!

Hey Steven, I want to use custom query means query having joins from multiple table, how can i use it in GenerateTableFetch processor?

what happens to your max value if you use uuid instead of incrementing number?

Steven, really good set of videos, very precise to the topic. Thoroughly enjoyed, thanks.

Thank you for this video, very helpful. I would like to ask you: how can you integrate this flow in case you need to create or replace the destination table? Like DROP IF EXISTS and CREATE IF NOT EXISTS? what are the additional processors involved, where would you put them and how do you set them? Or could you just change some settings from this flow?

i have to move tables from multiple schema to single schema( same table name and with same configuration) so i am using Listdatabase table to list the tables and then generate table fetch and max_value_columns as id( incremental value). but while i trying to insert new rows in table the state in generate table fetch is not updating.. is there any solution that howi ca i specify max_value_columns to update the state and have the new rows inserted in destination table

missed last 3 minutes of video because of sql screen on top of your desktop :(

Your timing could not have been better! Figuring this out was next on my list as I have to move data from one database to another. Still have to figure out the second part: deleting the data from the original table/database if the insert into the new table/database was successful. Your videos are very helpful so far, thank you!