mount-azure-blob-storage(Python)

dbutils.fs.mount(

  source = "wasbs://<container-name>@<storage-account-name>.blob.core.windows.net",

  mount_point = "/mnt/iotdata",

  extra_configs = {"fs.azure.account.key.<storage-account-name>.blob.core.windows.net":dbutils.secrets.get(scope = "<scope-name>", key = "<key-name>")})

df = spark.read.json("dbfs:/databricks-datasets/iot/iot_devices.json")

df.write.json("/mnt/iotdata/iot_devices.json")

dbutils.fs.ls("/mnt/iotdata/")

df = spark.read.json("/mnt/iotdata/iot_devices.json")

display(df)

%sql

CREATE DATABASE iotdata

LOCATION "/mnt/iotdata"

df.write.saveAsTable("iotdata.devices")

%sql

SELECT * FROM iotdata.devices LIMIT 10

%sql

DROP TABLE iotdata.devices

%sql

DROP DATABASE iotdata