title: External table in Blob Storage in Azure SQL(Not Azure SQL DW)
body: <p>Here is my script which I am trying to run in Azure SQL Database:</p>
  
  <pre><code>CREATE DATABASE SCOPED CREDENTIAL some_cred WITH IDENTITY = user1,   
      SECRET = '&lt;Key of Blob Storage container&gt;';  
  CREATE EXTERNAL DATA SOURCE TEST
  WITH
  (
      TYPE=BLOB_STORAGE,
      LOCATION='wasbs://&lt;containername&gt;@accountname.blob.core.windows.net',
      CREDENTIAL= &lt;somecred&gt;`enter code here`
  );
  
  CREATE EXTERNAL TABLE dbo.test
  (
  val VARCHAR(255)
  )
  WITH
  (
  DATA_SOURCE = TEST
  )
  </code></pre>
  
  <p>I am getting the following error:</p>
  
  <blockquote>
    <p>External tables are not supported with the provided data source type.</p>
  </blockquote>
  
  <p>My goal is to create external table in blob storage so that Hive query in HDInsight references to the same blob. The table needs to be managed through Azure SQL. What's wrong with this script? </p>