I have table column which consist of timestamp like "2021-06-11T13:16:52.083Z" . I want to extract month, year from this. Any suggestion how I can do this. I have tried dimension group like below.
dimension_group: date_field {
type: time
timeframes: [year, month, month_num, month_name, date]
sql: ${TABLE}."JSON":"_datalakeMetadata":"received"::string ;;
}
But whenever I select month it showing me the bellow error.
Whereas if I select date then I getting the correct output.
Any help or suggestion can save my day.