topic How to set timezone for SQL Warehouse? in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-set-timezone-for-sql-warehouse/m-p/3149#M314 <P>Hi, </P><P></P><P>I want to change the default time zone for SQL Warehoue in the SQL Persona. </P><P></P><P>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. </P><P></P><P>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.</P><P></P> Wed, 14 Jun 2023 05:20:54 GMT Mado 2023-06-14T05:20:54Z How to set timezone for SQL Warehouse? https://community.databricks.com/t5/data-engineering/how-to-set-timezone-for-sql-warehouse/m-p/3149#M314 <P>Hi, </P><P></P><P>I want to change the default time zone for SQL Warehoue in the SQL Persona. </P><P></P><P>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. </P><P></P><P>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.</P><P></P> Wed, 14 Jun 2023 05:20:54 GMT https://community.databricks.com/t5/data-engineering/how-to-set-timezone-for-sql-warehouse/m-p/3149#M314 Mado 2023-06-14T05:20:54Z Re: How to set timezone for SQL Warehouse? https://community.databricks.com/t5/data-engineering/how-to-set-timezone-for-sql-warehouse/m-p/3151#M316 <P>Thanks. </P><P></P><P>I am aware of the SET TIME ZONE command but I need to run this command every time I start the SQL warehouse. </P><P></P><P>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. </P><P></P><P></P> Wed, 14 Jun 2023 11:04:23 GMT https://community.databricks.com/t5/data-engineering/how-to-set-timezone-for-sql-warehouse/m-p/3151#M316 Mado 2023-06-14T11:04:23Z