Extract month from iso timestamp

  • 25 August 2021
  • 0 replies

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.

This topic has been closed for comments