A format validation column will check that your selected column conforms to a specific format.
You can provide regular expressions to check the format of column values such as phone numbers, email addresses, and alphanumeric characters. The regex you provide will vary depending on your selected target connection.
For example, you can check that a varchar
column contains emails using regex.
Select Format from the ‘Validation Type’ dropdown and the column that should conform to your chosen format.
You will then choose between the two format types available in the dropdown.
Currently, you can choose between Email and Custom.
If you have chosen Email you will find that we provide a default email format regex string.
If you have chosen Custom you can provide a regex string that fits the format you would like to check.
Click Ok at the top right to add this column validation.
Please remember to save this rule from the right-hand slideout if you do not choose to run this rule to save any column validation checks you have just added.
The regex you use will vary depending on the connection you have selected for this data quality rule. Learn more about regex for each connection type below.
Microsoft SQL Server and Azure Synapse format validation will check that your selected column conforms to a specific format. Learn more about the valid regex syntax for SQL Server and Azure Synapse here.
Snowflake Data Warehouse also uses regex to check that a column is in your chosen format. Learn more about the regex syntax for Snowflake here.