We currently store a lot of our timestamp data as UTC, however when doing analysis it’s common that we’ll need to convert the timestamps to some other timezone (eg.
US/Pacific). In Redshift this is accomplished by using the built in
CONVERT_TIMEZONE function. No such function seems to exist in Dremio, so is there any alternative way to convert between timezones easily? And if not are there any plans to add this functionality in the future?