I’m trying to do some data validation on each field of data in each column.
I have the validation parameters for each column heading, in a row on a separate table (Azure Data Catalog).
Data - (table name)
FirstName - (column)
Validation - (table name)
column_name | data_type | length - (columns)
FirstName | text | 20
So I would like to validate the values of “FirstName” against the validation parameters in the Validation table.
Any thoughts on this? Or if anything needs more clarification?