How to set timezone for SQL Warehouse?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2023 10:20 PM
Hi,
I want to change the default time zone for SQL Warehoue in the SQL Persona.
When I try to Edit the SQL warehouse settings in the "SQL Warehouses" section, I am not able to find any setting where I can set the time zone.
I am aware that I can set the time zone by running the query "SET TIME ZONE 'GMT+10';". However, I don't want t repeat it every time I run a query in the query editor. Instead, I want to see the local time zone as the default time zone of the SQL warehouse.
- Labels:
-
SQL
-
Sql Warehouse
-
Timezone
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2023 04:04 AM
Thanks.
I am aware of the SET TIME ZONE command but I need to run this command every time I start the SQL warehouse.
I am looking for a way to change the default time zone of the SQL warehouse. Something like "spark.sql.session.timeZone GMT+10" that I can set in the interactive cluster config.
