Elasticsearch timestamp format is not supported

Issue Summary

When using ES as data source all the timestamp columns is shown as unix timestamp only. Jusing the “Date/time” column type in the table visualization doesn’t convert it in date time format.

Technical details:

  • Redash Version: 8.0.0+b32245
  • Browser/OS:Chrome
  • How did you install Redash:Self-hosted via Digitalocean marketplace

I can’t reproduce this. The problem here is probably not the ES connector but the front-end. Please do the following and share what you see.

Use QRDS to SELECT the timestamp field wrapped in asterisks:

SELECT '***' || timestamp_field || '***' FROM query_xxxx

I used ES query (or lucene query) to query the data.