Question

Extract month from iso timestamp

  • 25 August 2021
  • 0 replies
  • 136 views

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