title: Reading azure databricks logs json file using azure databricks
body: <p>I have sent the data bricks logs to storage account by enabling diagnostic setting, Now I have to read those logs using azure data bricks for advance analytics. when I try to mount the path it works but reads wont work .</p>
  <pre class="lang-py prettyprint-override"><code>step 1- 
  
  containerName = &quot;insights-logs-jobs&quot;
  storageAccountName = &quot;smk&quot;
  config = &quot;fs.azure.sas.&quot; + containerName+ &quot;.&quot; + storageAccountName + &quot;.blob.core.windows.net&quot;
  sas = &quot;sp=r&amp;st=2021-12-07T08:07:08Z&amp;se=2021-12-07T16:07:08Z&amp;spr=https&amp;sv=2020-08-04&amp;sr=b&amp;sig=3skdlskdlkf5tt3FiR%2FLM%3D&quot;
  spark.conf.set(config,sas)
  
  step 2 
  
  df = spark.read.json(&quot;wasbs://insights-logs-jobs.gtoollogging.blob.core.windows.net/resourceId=/SUBSCRIPTIONS/xxxBD-3070-4AFD-A44C-3489956CE077/RESOURCEGROUPS/xxxx-xxx-RG/PROVIDERS/MICROSOFT.DATABRICKS/WORKSPACES/xxx-ADB/y=2021/m=12/d=07/h=00/m=00/*.json&quot;)
  
  
  Getting below error
  
   shaded.databricks.org.apache.hadoop.fs.azure.AzureException: Unable to access container $root in account insights-logs-jobs.gtjjjng.blob.core.windows.net using anonymous credentials, and no credentials found for them  in the configuration.
      at shaded.databricks.org.apache.hadoop.fs.azure.AzureNativeFileSystemStore.connectUsingAnonymousCredentials(AzureNativeFileSystemStore.java:796)
      at shaded.databricks.org.apache.hadoop.fs.azure.AzureNativeFileSystemStore.createAzureStorage.
  </code></pre>
  <p>Tried many approach but getting below error.
  [![enter image description here][1]][1]</p>