 Hey guys welcome to SS Unitech, so till this side and today we are going to see about the dynamic data set. So in the last video of this video series we have seen about the dynamic linker service and how we can create the parameters inside the linker service and how we can utilize all those. So if you haven't watched that video so before going forward I would strongly recommend to watch that video because we are going to utilize the same linker service in today's video. So go to the browser and we will try to see in the practical about the dynamic data sets. So here we are so if we can go in the manage and let me quickly go through about the linker service that we had created. So this is the linker service that we had created and under that you can see we are using these four parameters. So let me cancel this and go to the author tab. Here we can see the data sets. So I want to create a new data set. So let me click on this and go to the data set and the type. So the type that should be the Azure SQL. So let me search for the Azure SQL. Let me click on continue. Here let me call this as dynamic data set and this is for the Azure SQL and this is for the employee table. Now in the linker service I just want to add a new link service that you can see here that we had already created in the last video. So let me select that one. Now here if we are going to select this drop down will be not going to see any table. This is because if you have remember so in the last video we are using these four parameters and we did not pass any static values here. So let me click on the test connection and let me try to copy this and let me provide the default values here. So you will be able to see the tables available under that. So the TVI and the last is the password. Click on apply. Now if you can see here let me refresh this. So everything is okay. Click on under the table it is loading and now you are able to see this table. So here we do not have any option by which we can make this table as dynamic. Now so let me try to click on okay. So once we are clicking okay everything is okay. So it will be creating a new data set. So under this data set here we can scroll down. So under the table here we can see the add dynamic content option. And here we can also see the add dynamic content option. So the purpose of the dynamic data set is while we are going to select the tables it is possible that in the dev environment and the prod environment in the UAT environment in the last video we have seen. So it is possible that the environments are having the different table means. It might be employee underscore dev employee underscore UAT employee underscore prod. So those are the table names. So it is possible that your UAT environment your prod environment your dev environment will be having the different different names in the tables. So by which we can make that as dynamic as well. So here if we can see the schema. So it is also possible like the UAT is having under the degree of schema in another environment will be having another schema so that is also possible. So we can also make this as dynamic. But I am not going to make the dynamic of the schema only in the table. So let me click on add dynamic content here. So here as we can see we are not able to see any dynamic content here. So this is because we did not created any parameter. So let me cancel this go to the parameter section under this data set click on new and let me call this as table name and go to the connection again. And let me add dynamic content once select this. So this time you can see it is having data set dot table name. So while we were using the link service it was link service dot table name and here we are using the data set so it is data set dot table name. So this is the difference between data set level parameter and link service parameter. So that you can identify very easily. So let me click on OK. So everything looks OK. Let me publish all click on publish. So here we are creating the data set as well. So it is publishing. So published completed. So thank you so much for watching this video. If you really like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.