Forum Discussion
Fabric Notebook Locale Setting
HimanshuS-msft do you have an update on this ? I would like to test it out with some Notebooks we depend on, now that we are nearing the end of the year.
Hello JosueMolina
Sorry for the late reply .
If the requirement is to set locale to handle local timezone then yes. You can set timezone at session level by changing the Spark Config "
spark.sql.session.timeZone" or using SparkSQL SET command -
SET TIME ZONE - Spark 3.4.0 Documentation (apache.org)
Thanks
Himanshu
- JosueMolina2 years agoHelper III
Hi HimanshuS-msft
Sadly, this doesn't work as the purpose of changing the locale is to use pandas or pandas on Spark to create a Calendar with the proper Weekday names and Month names in Spanish without resorting to a replace as we add more variations of these names.will not output the desired weekday abbreviated namedf['date'].dt.strftime("%a")- v-cboorla-msft2 years agoMicrosoft Employee
Hi JosueMolina
Apologies for the delay in response.
Could you please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Thanks
- JosueMolina2 years agoHelper III
I managed to do this entirely using a locale format with Spark, foregoing Pandas usage. While the workaround was functional, the issue of not being able to set my own locale outside of Spark configs is not ideal.