Automated testing in azure datalake

I want to automate the testing process of azure data lake resources, especially azure data factory and azure SQL database. I tried creating some test cases in azure devops test plans and build pipelines for testing SQL database schema, mappings etc. I ran some SQL scripts for validating the schema etc. through YAML pipelines. Now i want to automate this SQL testing part. Is there any feature, plugin or any utility for azure devops for automating the SQL database testing in data lake. I could not find any pipeline tasks for SQL, like there are lot of tasks for selenium, dotnet applications but not for data lake.

I would highly appreciate any help and suggestion for this.