User Problem

All datetime datatype columns in the Atlassian Data Lake are stored in the UTC timezone. It would be useful to have the ability to change the timezone for datetime data that is stored in the Atlassian Data Lake. 

Suggested Solutions

Allow users to change the timezone for datetime data that is stored in the Atlassian Data Lake. 

Current Workarounds

Currently, users need to use a custom formula SQL workaround to adjust the timezone of their Atlassian data in Atlassian Analytics to match the timezone used in other Atlassian products. 

This can be done in Visual SQL by either applying a custom formula directly to the datetime column, or by creating a new custom formula column and then hiding the original datetime column. 

You can use the datesub( ) function to perform this data manipulation. In example, you may use the following custom SQL formula to subtract X hours from a datetime column named "Second of Created At":

datesub("Second of Created at", X, 'hour')