Create single Alteryx workflow that can perform data quality checks across 100 SQL tables

kumarmuni-b

Requirement: I need to create a single Alteryx workflow that can perform data quality checks across approximately 100 SQL Server tables.

The SQL Server database contains around 100 tables, each with different schemas and column headers. My goal is to run data quality checks—such as identifying null values, validating date formats, verifying data types, etc.—for all these tables using a single workflow.

I am currently able to create a workflow that performs these checks on one SQL table at a time. However, I’m unable to design a single workflow that can dynamically process all 100 tables in the database.

I attempted to use the Dynamic Input tool, but it failed because the tables have different schemas.

Could any professionals guide me on how to achieve this?

Attached is a sample of my metadata.

Let me know if any additional info needed.

metadata.xlsx

Yoshiro_Fujimori

Hi @kumarmuni-b ,

I understand  usually RDBMS can define constraints such as "NOT NULL", "UNIQUE", "PRIMARY KEY" to each column.

And you can define a column with data type such as "DATE", "DECIMAL".

If such constraints and data types are defined at creating a table, RDBMS checks the data when a record is added.

If RDBMS does the above job, you do not need to check the data on Alteryx.

If such constraints are not defined yet, you may want to consider adding it to RDBMS with ALTER TABLE statement.

Please let me know if you cannot have SQL Server check its own data quality for some reason.