Format

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.

How to Add Format Column Validation

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.

Choose a format type

If you have chosen Email you will find that we provide a default email format regex string.

Email format

If you have chosen Custom you can provide a regex string that fits the format you would like to check.

Custom format

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.

Regular Expression for Microsoft SQL Server, Snowflake Data Warehouse and Azure Synapse

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

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

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.