ADF Dataset Validation Validation Issues select count(1) from TABLENAME sql query / that is a problem
hi adf v1 azure sql external dataset { "$schema": "http://datafactories.schema.management.azure.com/schemas/2015-09-01/microsoft.datafactory.table.json", "name": "somename", "properties": { "type": "azuresqltable", "linkedservicename": "azuresqldatabase", "structure": [], "typeproperties": { "tablename": "schema.table" }, "availability": { "frequency": "day", "interval": 1 }, "policy": { //"validation": { // "minimumrows": 100 //} }, "external": true } } i thought validating rows on external sql dataset. defined validation rule. rows. but instead of executing validation while copy (i use query source sqlreaderquery) seams "select count(1) schema.table"...