Forum Discussion

Helper III

2 years ago

Fabric Notebook Locale Setting

I was able to run this code: locale.setlocale(locale.LC_TIME,"es_ES") before. But now the locale string is unsupported. Is there any way I can change the locale for a Notebook session. This help...

data engineering

Microsoft Employee

2 years ago

Hello JosueMolina ,
Thanks for the ask and using the Microsoft Q&A platform.\nAt this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Thanks Himanshu

JosueMolina
Helper III
2 years ago
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.
- HimanshuS-msft
  Microsoft Employee
  2 years ago
  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
  - JosueMolina
    Helper III
    2 years ago
    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.
    
    df['date'].dt.strftime("%a")
    will not output the desired weekday abbreviated name