Save default language of notebook into variable dynamically

[NLearn]

 For one of the requirements of project, I want to save default language of notebook into variable based on notebook path mentioned dynamically.

For eg: if first notebook given by user in widget is having default language as Python then variable value should set to "Python" and if notebook has been changed to Scala then variable value should to "Scala" automatically.

[Kaniz]

Hi @NLearn, To change the default language of a notebook in Databricks, you can select File -> Change default ce.... This will affect all the cells in the notebook that use the same language as the default one.

• You can also use magic commands to change the language of a single cell, such as %python, %r, %scala.... However, these commands have some limitations, such as not sharing variables between different langu....
• You can create a dropdown widget of all databases in the current catalog using dbutils.widgets.dropd.... This will allow you to access widgets defined in any language from Spark SQL while executing noteboo....

Based on these information, I think you can use a similar approach as in Python to get the default language of a notebook dynamically. You can use dbutils.widgets.dropdown("language", "default", [language for language in spark.catalog.listLanguages()]) to create a dropdown widget of all languages supported by Databricks. Then, you can use dbutils.widgets.select("language") to get the selected language from the widget. Finally, you can use this variable to store or retrieve the default language of the notebook.

I hope this helps! Let me know if you have any other questions. 😊

[NLearn]

Hi Kaniz,

Thank you for sharing this information. Actually, in requirement, User is passing notebook path through widget which can be based on any language "Python", "SQL" and "Scala". but user is not providing information regarding language through any widget so, we have to open notebook manually to see in which language notebook has been created. 

So Is there any way that by knowing notebook path, we can get its default language and save in some variable?