hey everyone welcome back to the channel PG analytics in this video I will talk about the concept of full refresh and incremental refresh now when we load the data in Tableau we have two options either we can keep the connection is live or we can keep the connection is extract now when we keep the connection is extract your data will be stored within Tableau now if you want to refresh that extract you have two options either you can do the full refresh or incremental refresh let's understand the difference between both so full refresh will always
fetch the entire data so basically when you do the full refresh it will replace your current data with the new data so it will be quite expensive on the database and it will take more time to refresh your extract whereas in case of incremental refresh it it will add only new record it will not touch the data that is already available so let's understand how we can implement this in Tableau so I have connected with Oracle database and I have dragged the table refresh so in the right hand side we have the options to keep
the connection type I have selected the extract and if I add it I can see extp we can do all rows that means full refresh second option is incremental refresh so by default it is full refresh if you don't touch anything if you don't change anything it will full refresh now if you select incremental refresh we have to Define we have to assign the column on which table will identify what was the last refresh and what new rows we have to add so I'll select the table to refresh is refresh identify the new rows using
the column order date so whenever new date added only those new records will be added in the refresh in the extract so I'll select okay and create the extract so I have just three column ID name and Order date and on order date we have applied the incremental refresh so I'll drag the name and Order date So currently I have data till 7th gen 2024 it means tblo will keep that date like we have data till 7th gen 2024 now when we do the incremental refres right now it will just load the data whatever is
available after 7th gen 2024 so to see that I'll just add some record here so I will add 8th gen one record for this it is added I'll just do the commit now when I do the refresh incremental refresh you will notice that new record will be added but if I do any if I add any data previous to 8th gen let's say 1 gen so in the database it is available one record is for 1 gen but if you do incremental refresh This Record will not be added so now it will be added whatever
data is added after 8th gen 2024 so let's see if I do incremental refresh you will notice first J 2024 is not added so incremental refresh will always add the new records so we have to assign a column on which table will identify the new columns but if I do full refresh now it will replace the current data and whatever data is available in the database will be stored in the refresh so now anti data will be replaced now you will get the first ch I hope the concept is clear thanks for watching the video
