Policy Element

Article
08/25/2015

Important

This topic and its sub-topics provides the JSON format that is supported by the older versions of Azure PowerShell. If you are using the July 2015 Release version of Azure PowerShell or later, see Policy Element for the latest JSON format. You can convert the JSON from old format to new format by using the tool: JSON Upgrade Tool

The Policy section in a JSON file that describes an Azure Data Factory table defines policies on the table.

Table Validation Policies

Validation policies enable you to check whether the data fulfills the condition that you specify. Specify a policy for a table as follows:

"policy":
{
    "validation":
    {
        "minimumSizeMB": 10.0
    }
}

"policy":
{
    "validation":
    {
        "minimumRows": 100
    }
}

Only one policy name can be specified for a table. If more than one policy is specified, an error will be shown. Validation policies do not apply to an on-premises SQL Server table.

The list of supported validation polices are shown in the following table:

Policy Name	Description	Applied To
minimumSizeMB	Validates that the data in an Azure blob meets the minimum size requirements (in megabytes).	Azure Blob
minimumRows	Validates that the data in an Azure SQL database or an Azure table contains the minimum number of rows.	Azure SQL Database Azure Table
validationPriorityOrder	Determines the order in which validation is performed on slices. Possible values are: OldestFirst (default) and NewestFirst.	All

Policy Element

Table Validation Policies

See Also

Additional resources