Can't format unix timestamps as date/time when using JSON data source

Issue Summary

I’m using the JSON data source and query parameters to fetch data from third-party APIs on-demand and display it on a dashboard. Unix times are returned from the API, and when I try to format them as Date/Time using Redash’s table visualization, only the raw unixtime input is displayed in the table. I would like to format the unixtimes as dates in the table, but Redash doesn’t seem to be recognizing the unixtimes as dates when using the JSON data source.

I’m doing everything I can to avoid using the Query Results data source because doing that introduces numerous other challenges. Fetching data only on-demand is essential in this use case.

Technical details:

  • Redash Version: v10 beta