Maintained with ☕️ by
IcePanel logo

Amazon SageMaker now offers 9 additional visual ETL transforms

Share

Services

Visual ETL in Amazon SageMaker now offers 9 new built-in transforms: “Derived column”, “Flatten”, “Add current timestamp”, “Explode array or map into rows”, “To timestamp”, “Array to columns”, “Intersect”, “Limit” and “Concatenate columns”. Visual ETL in Amazon SageMaker provides a drag-and-drop interface for building ETL flows and authoring flows with Amazon Q Developer. With these new transforms, ETL developers can quickly build more sophisticated data pipelines without having to write custom code for common transform tasks. Each of these new transforms address a unique data processing need. For example, use “Derived column**”** to define a new column based on a math formula or SQL expression, use “To timestamp**”** to convert a column to timestamp type, or build a new string column using the values of other columns with an optional spacer with the **“**Concatenate columns**”** transform. This new feature is now available in all AWS regions where Amazon SageMaker is available. Access the supported [region list](https://docs.aws.amazon.com/sagemaker-unified-studio/latest/adminguide/supported-regions.html) for the most up-to-date availability information. To learn more, visit our Amazon SageMaker [documentation](https://docs.aws.amazon.com/sagemaker-unified-studio/latest/userguide/visual-etl-supported-transforms.html).