topic Re: Fabric Notebook Locale Setting in Data Engineering

Fabric Notebook Locale Setting

JosueMolina — Wed, 06 Dec 2023 17:29:31 GMT

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 helps with multiple formats we use across Notebooks.

Re: Fabric Notebook Locale Setting

HimanshuS-msft — Wed, 06 Dec 2023 18:52:57 GMT

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

Re: Fabric Notebook Locale Setting

JosueMolina — Tue, 12 Dec 2023 14:30:49 GMT

@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.

Re: Fabric Notebook Locale Setting

HimanshuS-msft — Fri, 22 Dec 2023 21:20:38 GMT

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

Re: Fabric Notebook Locale Setting

JosueMolina — Fri, 22 Dec 2023 22:07:02 GMT

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

Re: Fabric Notebook Locale Setting

v-cboorla-msft — Thu, 18 Jan 2024 11:58:30 GMT

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

Re: Fabric Notebook Locale Setting

JosueMolina — Mon, 22 Jan 2024 21:07:05 GMT

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.

Re: Fabric Notebook Locale Setting

JosueMolina — Fri, 16 Feb 2024 16:24:35 GMT

This is not a solution as the main issue of setting a custom locale within the notebook has not been addressed.