Extract month from iso timestamp

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.

87d6a509-95aa-4db5-afb1-46c7c175c6f3.png

Whereas if I select date then I getting the correct output.

78cad93b-3e88-4f33-ae28-77b830b48ac1.png

Any help or suggestion can save my day.

0 0 439
0 REPLIES 0
Top Labels in this Space
Top Solution Authors