AWS – Amazon Redshift Spectrum now offers custom data validation rules
You can now use Amazon Redshift Spectrum to specify custom data validation rules for your external tables when querying the Amazon S3 data lake. This enhancement allows you to control how Redshift Spectrum processes data containing unexpected values such as unsupported UTF-8 characters or numeric overflow in your external tables.
Read More for the details.