title: exporting query result in Kusto to a storage account
body: <p>I get below error on running my kusto query(which i am still learning) in Azure Data Explorer. and the reason is result is more than 64 mb.. Now when I read the MS doc they mentioned we have something called Export which we can use to export the query result in a storage blob.. However I couldnt find any example as how we can do it? Did someone tried it? Can they provide a sample as how we can export to a storage account when my resulted set is more than 64 mb?</p>
  <p>Here is what I have for now, I have data in an external table which I would like to query. so for example if my external table name is TestKubeLogs and I am quyering</p>
  <pre><code>external_table(&quot;TestKubeLogs&quot;)
  | where category == 'xyz'
  </code></pre>
  <p>and then I get error as</p>
  <pre><code>The Kusto DataEngine has failed to execute a query: 'Query result set has exceeded the internal data size limit 67108864 (E_QUERY_RESULT_SET_TOO_LARGE).'
  </code></pre>
  <p>so now I am trying to export this data. How should I do it. I started writing this but how do I specify the category and table name.</p>
  <pre><code>.export
    async compressed
    to json (
      h@&quot;https://azdevstoreforlogs.blob.core.windows.net/exportinglogs;mykey==&quot;,
      
    )
  </code></pre>