QUARTER - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

QUARTER

Creates a new column containing the date-based quarter from a string that represents a date.

Note

Quarters are designated in the new column as 1, 2, 3, or 4.

  • 1 is January, February, and March.

  • 2 is April, May, and June.

  • 3 is July, August, and September.

  • 4 is October, November, and December.

Parameters

  • sourceColumn – The name of an existing column. The source column can be of type string, date, or timestamp.

  • value – A character string to evaluate.

  • targetColumn – A name for the newly-created column.

Note

You can specify either sourceColumn or value, but not both.

Example

{
    "RecipeAction": {
        "Operation": "QUARTER",
        "Parameters": {
            "sourceColumn": "DATETIME Column 1",
            "targetColumn": "DATETIME Column 1_QUARTER"
        }
    }
}