wget https://github.com/arifmarias/data-lake/blob/master/radio.json

azcopy login

azcopy login --tenant-id=9abad051-7ce5-4108-8b5c-5f7e198781c6

azcopy copy 'radio.json' 'https://datalakedemo200.blob.core.windows.net/datalake/radio.json'

abfss://[email protected]

configs = {
"fs.azure.account.auth.type": "CustomAccessToken",
"fs.azure.account.custom.token.provider.class": spark.conf.get("spark.databricks.passthrough.adls.gen2.tokenProviderClassName")
}

dbutils.fs.mount(
source = "abfss://[email protected]/",
mount_point = "/mnt/datalake",
extra_configs = configs)

%sql
DROP TABLE IF EXISTS radio;
CREATE TABLE radio
USING json
OPTIONS (
path "/mnt/datalake/radio.json"
)

%sql
SELECT * from radio