Export_Experiments.py

# Databricks notebook source
# MAGIC %md ## Export Experiments
# MAGIC 
# MAGIC Export multiple experiments and all their runs.
# MAGIC 
# MAGIC Widgets
# MAGIC * Experiments - comma delimited list of either experiment ID or experiment name. `all` will export all experiments.
# MAGIC * Output base directory - cloud mounted shared directory between source and destination workspaces.
# MAGIC * Notebook formats
# MAGIC * Use threads

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

# MAGIC %run ./Common

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

dbutils.widgets.text("1. Experiments", "") 
experiments = dbutils.widgets.get("1. Experiments")

dbutils.widgets.text("2. Output base directory", "") 
output_dir = dbutils.widgets.get("2. Output base directory")
output_dir = output_dir.replace("dbfs:","/dbfs")

all_formats = [ "SOURCE", "DBC", "HTML", "JUPYTER" ]
dbutils.widgets.multiselect("3. Notebook formats",all_formats[0],all_formats)
notebook_formats = dbutils.widgets.get("3. Notebook formats")

dbutils.widgets.dropdown("4. Use threads","False",["True","False"])
use_threads = dbutils.widgets.get("4. Use threads") == "True"

print("experiments:",experiments)
print("output_dir:",output_dir)
print("notebook_formats:",notebook_formats)
print("use_threads:",use_threads)

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

assert_widget(experiments, "1. Experiments")
assert_widget(output_dir, "2. Output base directory")

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

import mlflow
from mlflow_export_import.bulk.export_experiments import export_experiments
export_experiments(mlflow.client.MlflowClient(), 
                   experiments=experiments, 
                   output_dir=output_dir, 
                   notebook_formats=notebook_formats, 
                   use_threads=use_threads)

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

# MAGIC %md ### Display  exported files

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

import os
output_dir = output_dir.replace("dbfs:","/dbfs")
os.environ['OUTPUT_DIR'] = output_dir
output_dir

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

# MAGIC %sh 
# MAGIC echo "OUTPUT_DIR: $OUTPUT_DIR" ; echo
# MAGIC ls $OUTPUT_DIR

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

# MAGIC %sh cat $OUTPUT_DIR/experiments.json

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

# MAGIC %sh ls -lR $OUTPUT_DIR