 Hey guys welcome to SSUnitec social decide and today we are going to see about the validation activity. So before going forward, if you haven't watched the last video of this video series, so I would strongly recommend to watch that video where you can understand about the until activity. So let's see about the validation activity. So validation activity you can use to validate in a pipeline to ensure the pipeline only continues execution. Because it has validated the attached dataset reference exist. So it means for example, we are having a blob storage as a source and SQL server as a table in the destination. So we want to load from source to destination and in the source we are getting the file on every 30 minutes. So it may be on 30 minutes or 31 or 32, it will be little bit delay on that. So without fixing the time of the execution, we can use the validation activity. So it will be going to check whether source file is available there or not. If source file is available, then it will be loading the data into the destination. If source file is not there, then it will be waiting for the specified time that we will be specifying in the later of this video. So it will be waiting for that time and after that it will be checking again dataset is there or not. If dataset is there, then it will be continue to load into the table. If not, then it will be waiting and after some time it will be checking again. So let's quickly go and we'll see the requirement and after that we'll see quickly about the until activity that we have seen in the last video. So first of all, this is our input blob storage container. So under this container, we are having this employee file. So as of now we can see employee file is there. So we just want to load this employee file data from here to SQL Server Table. That is the EMP data. Now here we can go and we'll see about the until activity that we have seen in the last video. So in the until activity, so what it is doing? We have declared a variable and this until activity will be executing until this status variable value is false. Once this value is true, until activity will be stopped and your copy data activity will be executing. So here in the expression, we have set this as bool that is true. We are checking and in this first we are waiting for some time. So your pipeline will be paused next in the get meta data activity. We are checking the data set. So whether data set is there or not, so we are using the exist property of this. So if data set is there, then this exist property will true, otherwise this will be false. So in the if condition, we are checking as we can see that value of the exist. If this value is true, then we are simply setting the variable value as true. That is the status variable. So your until activity will be stopped. So this is we have done in the last video. Well, that's an activity. Let me create a new pipeline and let me call this as validation activity. Now here we can search for the validation activity and we can drag and drop. So this is very straightforward. Here we are having the description of this task and the name. So we can call this as validation live as it is next under the setting. So under the setting, we need to set the data set by which we want to check. So we have already created the data set in the last video. So I'm going to use the same. So that is the until activity. Let me open it and quickly show you that. So if you can see the link service, then this is pointing to SSU testing, which is a storage account that is SSU testing. And under that, we have this input. So this is the input location. And then after MP dot 85. So this is the data set next here, we can see the timeout. So timeout is very large and as per your requirement, you can set that next the sleep. So it will be checking every 10 seconds. So your validation will be stopped for 10 seconds and again it is checking whether the file is there. If file is there, then it will proceed. If not, then it will wait again 10 seconds and then we'll be checking again. So this is the only thing that you need to do. Next we can simply use the copy data activity to load the data. So we can simply connect with this. And in this source, we can use the same data set that is the until activity. That's it. Go to the sync. We have already created the sync correction in the last video. So I'm going to use the same. So for each MP, go to the mapping, import the schema. So here everything looks good. So that's it. We can execute and we'll see. So in the first attempt, this will be executed successfully and we'll be loading the data because the employee file is there that you can see MP employee.txt. So it is validating now. We can check in the output side. Validation is in progress. So everything is succeed because in the validation activity in the output, we can see the exist is true. So that's why it is executed. Now let me try to delete this EMP.txt from here. So now your source file will not be there. And now we want to debug this pipeline. So this time your validation activity will be executing and your pipeline will be paused for 10 seconds. So this is in progress as you can see. Now we can refresh. So this is in progress and nothing is going to happen because this validation activity is not finding the source from there. So that's why it is in paused. Now here let me try to upload a file from here. So upload in the blob storage, set the file. So this EMP.txt, let me click on open and all right, if already exists, so uploading this file. So this is uploaded successfully there. Now go back to the Azure Data Factory and try to refresh it now. So this time your file is there. So that you can see your validation activity now is getting as true. So that's why it is succeed. Otherwise it was paused as we have already seen. In the copy data it is already loaded in the SQL Server table. So we can check from this watch. So here we can see this is succeed and total three rows are inserted. So I hope guys you have clear understanding about the validation activity. If you have still any doubt then you can ask your question in the comment box. I'll try to response there. Thank you so much for watching this video. See you in the next video.