Export and import Databricks notebooks

Databricks can import and export notebooks in the following formats:

  • Source file: A file containing only source code statements with the extension .scala, .py, .sql, or .r.

  • HTML: A Databricks notebook with the extension .html.

  • Databricks .dbc archive.

  • IPython notebook: A Jupyter notebook with the extension .ipynb.

  • RMarkdown: An R Markdown document with the extension .Rmd.

Import a notebook

You can import an external notebook from a URL or a file. You can also import a ZIP archive of notebooks exported in bulk from a Databricks workspace.

  1. Click Workspace Icon Workspace in the sidebar. Do one of the following:

    • Next to any folder, click the Menu Dropdown on the right side of the text and select Import.

    • In the Workspace or a user folder, click Down Caret and select Import.

      Import notebook
  2. Specify the URL or browse to a file containing a supported external format or a ZIP archive of notebooks exported from a Databricks workspace.

  3. Click Import.

    • If you choose a single notebook, it is exported in the current folder.

    • If you choose a DBC or ZIP archive, its folder structure is recreated in the current folder and each notebook is imported.

Import a file and convert it to a notebook

You can convert Python, SQL, Scala, and R scripts to single-cell notebooks by adding a comment to the first cell of the file:

# Databricks notebook source
-- Databricks notebook source
// Databricks notebook source
# Databricks notebook source

To define cells in a script, use the special comment shown below. When you import the script to Databricks, cells are created as marked by the COMMAND lines shown.

# COMMAND ----------
-- COMMAND ----------
// COMMAND ----------
# COMMAND ----------

Export notebooks

Note

When you export a notebook as HTML, IPython notebook (.ipynb), or archive (DBC), and you have not cleared the command outputs, the outputs are included in the export.

To export a notebook, select File > Export in the notebook toolbar and select the export format.

To export all folders in a workspace folder as a ZIP archive:

  1. Click Workspace Icon Workspace in the sidebar. Do one of the following:

    • Next to any folder, click the Menu Dropdown on the right side of the text and select Export.

    • In the Workspace or a user folder, click Down Caret and select Export.

  2. Select the export format:

    • DBC Archive: Export a Databricks archive, a binary format that includes metadata and notebook command outputs.

    • Source File: Export a ZIP archive of notebook source files, which can be imported into a Databricks workspace, used in a CI/CD pipeline, or viewed as source files in each notebook’s default language. Notebook command outputs are not included.

    • HTML Archive: Export a ZIP archive of HTML files. Each notebook’s HTML file can be imported into a Databricks workspace or viewed as HTML. Notebook command outputs are included.