Posted On: Feb 10, 2022

AWS Glue DataBrew customers are now able to custom sort one or multiple columns on their datasets in DataBrew. It enables customers to search and group column values more easily. This transformation is intended for users who want to arrange their data in one or more dimensions using various sorting orders without writing any code.

Customers can sort columns in ascending/descending order. Custom sorting allows you to create a specific order to arrange the column values according to your particular needs. You can also view an ordered column immediately without specifying a transformation. Customers can use sorting to organize and experiment with the columns for preliminary analysis on the console, and define sorting transformations for data analysis and reporting.

This transformation is available in most public AWS Regions and AWS GovCloud (US-West). See where AWS Glue DataBrew is available by using the AWS Region Table. AWS Glue DataBrew is a visual data preparation tool that makes it easy to clean and normalize data using over 350 pre-built transformations, all without the need to write any code. You can automate filtering anomalies, converting data to standard formats, correcting invalid values, and other tasks.

To get started, see the following resources: