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"...