You are working on a data pipeline that ingests data from multiple sources. You have noticed that some of the data fields are empty or contain inconsistent values. How would you investigate and resolve these data consistency issues using AWS Glue DataBrew?
