Automating conversion of python scripts to databricks notebook

Question

I'm looking to convert a Python .py file into a format compatible with Databricks, where the file can be split into multiple cells without using the Databricks GUI. Eventually, I’d like to automate this process. What’s the minimal code needed to create a title cell and separate the rest of the code as executable Python cells?

Here’s what I’ve tried, but it doesn’t seem to work as expected:

%md#

Title

%python

My code goes here

I could manually copy output from a Databricks notebook, but I'm hoping for a more minimal and streamlined solution. Any suggestions?

Answer 1

Hi @Stephen-5002

Welcome to Microsoft Q&A platform and thanks for posting your query here.

To create a Databricks notebook from your Python file, start with this line:

# Databricks notebook source

For any header or markdown text in your notebook, add this right after the first line:

# MAGIC %md

To separate your cells, use the following line, making sure to include empty lines before and after:

# COMMAND ----------

That's all you need! Any Python code can just be added without any special commands because it’s already recognized as Python due to the .py file extension. So, your code should look like this:

# Databricks notebook source
# MAGIC %md # MAGIC 
# Title 
# COMMAND ---------- 
print("Any Python code!")

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.