Dataset updating Adult dating mt ohio vernon
Idea from @Jeff_J_Jordan via Twitter: Currently in Azure Data Factory once a dataset is deployed, you cannot change the availability for the dataset.
Using bind variables makes the statement reusable with different input values.
Using bind variables also improves query performance in the database, eliminates the need for special handling of literal quotation marks in the input, and protects against SQL injection attacks.
This also, doesn't work well with deploying Azure Data Factories from Visual Studio using a config file.
If the availability could be updated it would be rather easy to update the config file and publish the data factory.
If you attempt to change the availability you get the following error message: “Updating the availability section of a Dataset is not supported.