all right everyone so in this video we are going to learn how we can automate the entire process of loading the data to our staging table and running the transform app for now we have a daily summary data import their source and we have also a daily summary data import transform app and we have to run them manually so you have opened your data source click on door Oh recalls you know your audio record and then click on transform in order to send the data into your target table so what we we can actually do what we call a create basically a scheduled data import in order to automate this process ok so let's see how we can do that so look for schedule a data import here click on create and then it's very simple all you need to do is here give it a title for your schedule data impose I'm going to I'm going to put for example schedule data import daily summary and make sure you select the right data source that's where we have all the information such as which transform happened so on so we have here daily sub summary data input and select the time that you want so I'm going to run this on daily basis at 8:00 p.m. that's it that's all you need to do every day my coffee 19 table will have new records we it will be created after around a p.m. and I will have the summary thank you for watching