QUARTER - AWS Glue DataBrew


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


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.

  • 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.


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


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